<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">try it without 'public',<br>
at least that works for me on linux<br>
<div class="moz-signature">------------------------------------------------------------<br>
<b>Jeff Lake K8JSL</b><br>
<a href="http://www.michiganwxsystem.com">MichiganWxSystem</a><br>
<a href="http://www.allisonhouse.com">AllisonHouse</a><br>
<a href="http://www.grlevelxstuff.com">GRLevelXStuff</a><br>
-----------------------------------------------------------------<br>
</div>
On 4/12/2013 18:14, David Rush wrote:<br>
</div>
<blockquote
cite="mid:CAPv=ZR1EkPK0O+8q96fGoVQ8pRArXScLE2k7T7qUX-_7gpD1rw@mail.gmail.com"
type="cite">
<div dir="ltr">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.
<div><br>
</div>
<div style="">I ran this:</div>
<div style=""><br>
</div>
<div style="">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 <br>
</div>
<div style="">
<br>
</div>
<div style="">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).</div>
<div style=""><br>
</div>
<div style="">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;".</div>
<div style=""><br>
</div>
<div style="">But when I go into psql, I can't find the
public.us_counties table that I thought I just added created:</div>
<div style=""><br>
</div>
<div style="">
<div>mygisdb=# select * from public.us_counties;</div>
<div>ERROR: relation "public.us_counties" does not exist</div>
<div>LINE 1: select * from public.us_counties;</div>
<div> ^</div>
<div>mygisdb=# select table_schema, table_name,table_type from
information_schema.tables where</div>
<div>table_schema not in ('pg_catalog','information_schema');</div>
<div> table_schema | table_name | table_type</div>
<div>--------------+-------------------+------------</div>
<div> public | geography_columns | VIEW</div>
<div> public | geometry_columns | VIEW</div>
<div> public | spatial_ref_sys | BASE TABLE</div>
<div> ch01 | lu_franchises | BASE TABLE</div>
<div> ch01 | fastfoods | BASE TABLE</div>
<div>(5 rows)</div>
<div><br>
</div>
<div style="">Poking around with pgAdmin III I can't find in
anywhere, either.</div>
<div style=""><br>
</div>
<div style="">Is the new table us_counties hiding somewhere?
Or did it quietly fail? Or what?</div>
<div style=""><br>
</div>
<div style="">David</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</body>
</html>