[Mapserver-users] mapserver+postgis schema

[Alexandros Chimarios]

Also add the index oid on your query like this :

DATA "the_geom from gis.it_iso using UNIQUE oid using SRID=-1"


Please notice that you should have created the indexes (oid, srid)
on your DB. Please refer to the PostGIS manual.



On Thursday 22 April 2004 16:50, Alessio Ferrario wrote:
> Hi all,
> Can I use schema in a postgres layer?
> my map file look like this:
> ....
> CONNECTIONTYPE POSTGIS
> CONNECTION "user=dbuser  dbname=ITALIA33  host=192.168.0.1 port=5432"
> DATA "the_geom from gis.it_iso using SRID=-1"
> ....
>
> I software configuration is:
> postgres 7.3.4 running on Red Hat Linux 9
> mapserver 4.0
> php 4.3.4
> apache 2.0.47
>
> thanks in advance
> best regards
> Alessio