[postgis-users] Trouble seeinglisting tables

[pcreso at pcreso.com]

Nothing obvious that I can see.


psql -d <db>

\d                  # should list the tables
\d mytable     # should list the structure of the table "mytable"
select * from mytable;  # should list the contents of mytable.


If you can post the outputs from these commands (the text before the "#") we can probably offer more informed advice.

Cheers

  Brent Wood



--- On Tue, 2/14/12, Bistrais, Bob <Bob.Bistrais at maine.gov> wrote:

From: Bistrais, Bob <Bob.Bistrais at maine.gov>
Subject: [postgis-users] Trouble seeinglisting tables
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Date: Tuesday, February 14, 2012, 9:58 AM




 
 










I am having trouble on a pretty basic level.  I loaded a
couple shapefiles into PostGIS.  I can see that they successfully loaded when I
use pgAdmin.  But when I go to command line, I have trouble.  I can do a \d
command and see the tables exist in the database.  But if I do a select * from
mytable; I get an errer, “relation “mytable” does not exist. 
What am I doing wrong here? 







-----Inline Attachment Follows-----

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120213/34793708/attachment.html>