[postgis-users] Noob question with shp2pgsql

[Jeff Lake]

try it without 'public',
at least that works for me on linux
------------------------------------------------------------
*Jeff Lake K8JSL*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
-----------------------------------------------------------------
On 4/12/2013 18:14, David Rush wrote:
> 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

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