Felipe K. De Boni felipedeboni
felipedeboni
/ CEP.sql
Created
August 13, 2013 00:03
Import data from GPBE tables (format as .csv, with ; as delimiter and quotes with ")
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* =============================================================================================================================== | |
| This will get data from GBPE (previously) converted to CSV and: | |
| * Create temporary tables | |
| * Import data from: LOG_LOGRADOURO.csv, LOG_LOCALIDADE.csv, LOG_BAIRRO.csv into the temp tables | |
| * Decrypt CEP column and create a new table with the following fields: cep, logradouro, bairro, cidade, uf, uf_sigla | |
| * Dropping the temp shit | |
| * Update PG Query Builder with an EXPLAIN ANALYZE | |
| This script can be used to update an existing table (with same struct of course) |