> como assim amigo usar o parametro -W? onde usar? É que eu sou novo no
> postgis, poderia me explicar melhor?
Não indicaste que método usas para subir os shapes a PostgreSQL.
Assumindo que usas o shp2pgsql, seria assim:
shp2pgsql -s 4326 -g geom -D -I -W iso-8859-1
C:\Users\Jonnathann\Desktop\Shapefiles\Municipios.shp tb_municipios
bd_nome | psql -d bd_nome
Parametros shp2pgsql:
-s <srid> Set the SRID field. Defaults to -1.
(-d|a|c|p) These are mutually exclusive options:
-d Drops the table, then recreates it and populates it
with current shape file data.
-a Appends shape file into current table, must be
exactly the same table schema.
-c Creates a new table and populates it, this is the
default if you do not specify any options.
-p Prepare mode, only creates the table.
-g <geocolumn> Specify the name of the geometry/geography
column (mostly useful in append mode).
-D Use postgresql dump format (defaults to SQL insert statments.
-G Use geography type (requires lon/lat data).
-k Keep postgresql identifiers case.
-i Use int4 type for all integer dbf fields.
-I Create a spatial index on the geocolumn.
-S Generate simple geometries instead of MULTI geometries.
-W <encoding> Specify the character encoding of Shape's
attribute column. (default : "WINDOWS-1252"), iso-8859-1 (codificacao
Latin-1)
-N <policy> NULL geometries handling policy (insert*,skip,abort)
-n Only import DBF file.
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
