[mapserver-users] postgis layer and ogr

[HERMANGE Albin]

hi,

i want to display a postgis layer using the ogr driver

the mapserver native postgis connection works very well
                CONNECTION "user=myuser password=mypwd dbname=mydb host=127.0.0.1 port=5432"
                CONNECTIONTYPE POSTGIS
                DATA "geom from (select * from mytable) as foo using unique gid using SRID=-1"


but when i want to display the same layer with the gr driver , mapserver crash
                CONNECTIONTYPE OGR
                CONNECTION "PG:user=myuser password=mypwd dbname=mydb host=127.0.0.1 port=5432"
                DATA "SELECT * FROM mytable "



i think the CONNECTION string is wrong but i cannot find the correct one


can u help me with this connectionstring ?




thx,

albin


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080421/db04d5a6/attachment.htm>