[MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema

[Venkat Rao Tammineni]

Hi,
Here is my Example .I think it helps you.

Layer # Layer starts here
  Name "GMM 100" #name of the layer
  ConnectionType POSTGIS #connection type
  Connection "host=192.168.1.158 dbname=GIS password=administrator
user=postgres port=5432" #connection type.
  Data "the_geom from rgp_gis_gmm_100_metros"   #table name

Thanks and Regards
Venkat.





-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Ritesh
Ambastha
Sent: Wednesday, July 16, 2008 2:44 PM
To: mapserver-users at lists.osgeo.org
Subject: [MAPSERVER-USERS] Connection parameter errors while using Postgres
DB Schema


Hello Readers, 

I am facing a problem in defining the DATA path in mapserver while using
PostGIS. 

I have two schemas, lets say 'a' and 'b' in a database 'd'

Now, I want to access tables of schema 'a' in the mapserver layer. 

I define DATA path like this: 

DATA "the_geom FROM a.table_name USING UNIQUE id SRID -1" 

Please pour in your thoughts for defining schema in the connection/data
parameters.

Thanks,
Ritesh Ambastha
-- 
View this message in context:
http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc
hema-tp18483547p18483547.html
Sent from the Mapserver - User mailing list archive at Nabble.com.

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users