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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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?
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users