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.bistr...@maine.gov> wrote:

From: Bistrais, Bob <bob.bistr...@maine.gov>
Subject: [postgis-users] Trouble seeinglisting tables
To: "PostGIS Users Discussion" <postgis-users@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to