[postgis-users] Trouble seeinglisting tables

[Bistrais, Bob]

I added the SRID to my Data line:

DATA "the_geom from Metwp100Poly USING SRID=26919 USING Unique gid"

 

And here is the latest debug output:

 

With query string: DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from
Metwp100Poly WHERE the_geom && setSRID('BOX3D(134000
4692598.18523154,890900 5307401.81476846)'::BOX3D, 26919 )

 

 

________________________________

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