Insert cities into the database

IBGE registration code

link

Copy everything from

CREATE TABLE cidades (
    id integer NOT NULL AUTO_INCREMENT,
    nome varchar(250),
    codigo_ibge integer,
    estado_id integer,
    populacao_2010 integer,
    densidade_demo numeric(10, 2),
    gentilico varchar(250),
    area numeric(10, 3),
    PRIMARY KEY ('id')
);

and runs on your Postgre

  

also copy the CREATE TABLE quoted above

The IBGE website provides all cities through some file types. Take a look at this link, which already has sqls for postgre

link

I have a sql that I use, however it is for MySql , but I believe that with few changes you can achieve your goal.

The file is available at: link

All States and Municipalities (or almost all ...) of Brazil, with the possibility of entering new countries, districts / states and municipalities. (Columns with prefix to facilitate JOINs and maintain organization ...).

If you have problems with accented characters, open the file in any text editor and save it with UTF-8 encoding, which resolves, or copy and paste the code directly into MySQL (without using import ...)

I'll leave the Github project link:

Github - SQL of Tables with Registers of All Countries and Nations (with BACEN Code) + States and Federations (c / DDD and IBGE Code) Brazilian + Cities and Municipalities (c / IBGE Code) Brazilians, including 31 administrative regions of the DF, Islands and Remote Areas of the World.