[postgis-users] Noob question with shp2pgsql

[David Rush]

Total noob to PostgreSQL and PostGIS here.  Trying to follow examples from
the Obe+Hsu book (1st Ed) in using shp2pgsql from the command line to
import some tiger county data.

I ran this:

shp2pgsql -s 4269 -g geom_4269 -W LATIN1
c:/users/david/downloads/tl_2012_us_county/tl_2012_us_county.shp
public.us_counties psql -h localhost -U postgres -p 5432 -d mygisdb

Thanks to an archive of this list that led me to add the "-W LATIN1" param
(it was failing with an error w/out it).

Now the command runs for several minutes, spitting out mostly zillions of
hex digits, with no overt errors.  Last line it spits out is "COMMIT;".

But when I go into psql, I can't find the public.us_counties table that I
thought I just added created:

mygisdb=# select * from public.us_counties;
ERROR:  relation "public.us_counties" does not exist
LINE 1: select * from public.us_counties;
                      ^
mygisdb=# select table_schema, table_name,table_type from
information_schema.tables where
table_schema not in ('pg_catalog','information_schema');
 table_schema |    table_name     | table_type
--------------+-------------------+------------
 public       | geography_columns | VIEW
 public       | geometry_columns  | VIEW
 public       | spatial_ref_sys   | BASE TABLE
 ch01         | lu_franchises     | BASE TABLE
 ch01         | fastfoods         | BASE TABLE
(5 rows)

Poking around with pgAdmin III I can't find in anywhere, either.

Is the new table us_counties hiding somewhere?  Or did it quietly fail?  Or
what?

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130412/60722d18/attachment.html>