psql

PSQL command linePSQL da riga di comando

Below some commands line I used to manage spatial data:

Import shape to postgis

shp2pgsql -s epsg_code -c -g geometry_column -I -t 2D -W LATIN1 shapename schemaname.tablename | psql -h hostname -d mydb -U username

Di seguito alcuni comandi psql che uso per gestire i dati geografici:

Import shape to postgis

shp2pgsql -s epsg_code -c -g geometry_column -I -t 2D -W LATIN1 shapename schemaname.tablename | psql -h hostname -d mydb -U username