We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
CREATE TABLE test_grade_level1 AS SELECT gid, pop, pop_fem_perc, iif(pop>0,round(100*dom_ocu/pop)::int,0::int) as dom_ocu_perc, grid_ibge.draw_cell(gid) geom FROM grid_ibge.censo2010_info WHERE grid_ibge.gid_to_level(gid)=1;
pg_dump -t test_grade_level1 postgres://postgres@localhost/ibge | gzip > test_grade_level1.sql.gz