Skip to content

Instantly share code, notes, and snippets.

Felipe De Boni felipedeboni

  • Hello Innovation
  • Porto Alegre
Block or report user

Report or block felipedeboni

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
felipedeboni / CEP.sql
Created Aug 13, 2013
Import data from GPBE tables (format as .csv, with ; as delimiter and quotes with ")
View CEP.sql
/* ===============================================================================================================================
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)
You can’t perform that action at this time.