[postgis-users] shp2pgsql oddities

[Aaron Cline]

Excellent.  Works like a charm.

Thanks Steffen.

Steffen Macke wrote:

>Hi Aaron,
>
>  
>
>>shp2pgsql -c northamerica.shp northamerica giswxtest
>>
>>Lots of stuff scrolls past the screen that look like Insert statements.
>>    
>>
>
>This is correct - shp2pgsql only creates the insert statements. You
>have to execute them e.g. using psql. You can redirect the shp2pgsql output to
>psql using | or you can redirect the output to a file and execute the 
>statements from that file.
>
>The following is an example - you may have to add additional parameters
>for host/username to psql as required:
>
>shp2pgsql -c northamerica.shp northamerica giswxtest | psql -d giswxtest
>
>Steffen
>
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>  
>