Da: http://postgis.refractions.net/docs/ch04.html#id2523645
An example session using the loader to create an input file and uploading it might look like this:
# shp2pgsql shaperoads myschema.roadstable > roads.sql
# psql -d roadsdb -f roads.sql
A conversion and upload can be done all in one step using UNIX pipes:
# shp2pgsql shaperoads myschema.roadstable | psql -d roadsdb
--strk;
On Mon, Jul 03, 2006 at 12:51:00PM +0200, Fabio D'Ovidio wrote:
Qualcuno potrebbe confermarmi se questa operazione in ambiente Windows è valida ?
nomeDB-# EXECUTE \! shp2pgsql -a shapefile.shp nometabella_a_cui_attacare_il_SHP
sto cercando di mettere in una stessa tabella postgis due o più SHP.
Il comando viene eseguito ma la tabella sembra non aggiornarsi.
Grazie
********************************************************************************************
Ing. Fabio D'Ovidio
WebGIS Staff
Planetek Italia Srl
via Massaua, 12 - 70123 Bari - Italy
web : http ://www.planetek.it
e-mail : dovidio@planetek.it
********************************************************************************************
Content-Description: Attachment information.
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.
---- File information -----------
File: planetek.gif
Date: 28 Feb 2006, 16:15
Size: 1899 bytes.
Type: Unknown
_______________________________________________
Gfoss mailing list
Gfoss@faunalia.com
http://www.faunalia.com/cgi-bin/mailman/listinfo/gfoss
--
/"\ ASCII Ribbon Campaign
\ / Respect for low technology.
X Keep e-mail messages readable by any computer system.
/ \ Keep it ASCII.