[postgis-users] [?? Probable Spam] Re: Trouble seeinglisting tables

[Francisco Salas Rosette]

Bob, this is one example for connection in mapserver with postgis , in DATA
section do you put the selection. 

on the other hand, do you review in the geometry_columns table in public
scheme , if there exists you table?

 

the  geometry_columns table , describe projection, geometric columns , etc.

 

 

  LAYER

    CONNECTION "dbname=datosfg user=postgres password=postgres
host=localhost"

    CONNECTIONTYPE POSTGIS

    DATA "wkb_geometry from suelo USING SRID=4267001 USING Unique gid"

    METADATA

      "srid"              "4267001"

      "table_name"            " suelo"

      "cant_class_temat" "0"

      "field_list"    "gid, rugosidad, humedad, profundidad, suelo"

    END

    NAME "Suelos"

    STATUS ON

    TEMPLATE "ttt"

    TYPE POLYGON

    UNITS METERS

    CLASS

      NAME "Suelos"

      STYLE

        ANGLE 360

        COLOR 174 183 180

        OPACITY 100

        OUTLINECOLOR 35 80 65

        SYMBOL 0

      END

    END

  END

 

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 04:47 p.m.
Para: PostGIS Users Discussion
Asunto: [?? Probable Spam] Re: [postgis-users] Trouble seeinglisting tables

 

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