[postgis-users] [!! SPAM] Trouble seeinglisting tables

[Bistrais, Bob]

Hello Francisco,

 

I loaded the data using the PostGIS Shapefile and DBF Loader.  The table
has a column called the_geom.  I don't see any column for the SRS or
projection.

 

I made some progress- I forgot to put quotes on my table name, so my
select command should be:

SELECT * from "mytable";

-and that works correctly.

 

But, I am still not able to see my layer in MapServer.  I have posted to
the MapServer list as well, to see if anyone can help.  I get a
MapServer error that says:

ERROR: relation "mytable" does not exist...

 

 

 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Francisco Salas Rosette
Sent: Monday, February 13, 2012 4:44 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] [!! SPAM] Trouble seeinglisting tables

 

Bob, do you review if there exists mytable in the geometry_columns
table?

How do you loaded this table?

 

Francisco salas 

 

 

De: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] En nombre de
Bistrais, Bob
Enviado el: lunes, 13 de febrero de 2012 03:58 p.m.
Para: PostGIS Users Discussion
Asunto: [!! SPAM] [postgis-users] Trouble seeinglisting tables

 

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?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120213/1a93241b/attachment.html>