David Hipwell ha scritto:
David Hipwell ha scritto:
Hi David
Hi.
I’m a new MapServer user, and I’ve got a few questions about
connecting to Postgres:
1. How do you connect to a postgres database, both locally and over a
network,
with this:
il local
CONNECTIONTYPE POSTGIS
CONNECTION "user=youruser password=yourpassword dbname=yourdb
host=localhost"
DATA "the_geom from yourtable"
aver the network only change 'host' keyword localhost with ip address in
the network
2. How do I pull spatial and non-spatial layers through the
connection, and
Sorry but I don't understand
3. Is there any way to join the two tables based on a common column.
example:
in data
DATA "the_geom from (select * from table1 a join table2 b) as foo using
unique gid"
Any help here would be a great asset.
I hope this can help
W
--
Please no .doc, .xls, .ppt, .dwg:
https://www.faunalia.it/dokuwiki/doku.php?id=public:OpenFormats
Walter Lorenzetti
email+jabber: [EMAIL PROTECTED]
www.faunalia.it
Cell: (+39) 347-6597931 Tel+Fax: (+39) 0587-213742
Piazza Garibaldi 5 - 56025 Pontedera (PI), Italy
