[postgis-users] Trouble seeinglisting tables

[Bistrais, Bob]

Hi Brent,

 

One quick observation- I need to quote the table name with the \d
mytable and select statements, in order to get any output, otherwise it
says "did not find relation name Metwp100Poly".  Does that sound right?


 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
pcreso at pcreso.com
Sent: Monday, February 13, 2012 5:06 PM
To: PostGIS Users Discussion
Cc: Bistrais, Bob
Subject: Re: [postgis-users] Trouble seeinglisting tables

 

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/c4158cb4/attachment.html>