[postgis-users] shp2psql problem

[Jeff Lounsbury]

Do a bunch of sql statements get output to the screen as you run it? You have to
pipe that output into the database to actually run them as shp2pgsql does not
connect to the database itself.
ex:
shp2pgsql <arg1> <arg2> <arg3> | psql <dbname> -h<host> -p<port>
-Jeff



javier garcia - CEBAS wrote:

> Hi all;
> I've seen that other problems related to shp2psql have benn posted previously
> to the list; but it didn't help me.
>
> I've an absolute beginner with postgis, and I've just installed it.
>
> I've got a shapefile (ESRI Arcmap8.1) that would like to import into
> Postgres. So, when I saw this program I was absolutely happy.
> I've run it and it appears to run correctly as no error message appears, but,
> eventually, when I look up the new table in the database it doesn't appears.
> So, it is simply not created.
>
> The shapefile is rather big, (about 5000 polygons).
>
> What could be the source of the problem?
>
> Best regards
>
> Javier
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users