Hi Gimborgno,
I think all you need to do is add the schema name as the first argument
to the AddGeometryColumn procedure. E.g. replace:
SELECT AddGeometryColumn('table', 'field', 4326, 'POINT', 2);
with:
SELECT AddGeometryColumn('new_schema', 'table', 'field', 4326, 'POINT',
2);
Thanks,
Mark Lidstone
Tel: +44 (0)23 80232222; Fax: +44 (0)23 80232891
BMT Cordah Ltd
Grove House
7 Ocean Way
Ocean Village
Southampton
SO14 3TJ
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
gimbrogno
Sent: 11 August 2008 12:34
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] How to add spatial functions to a custom schema
Hi all,
I have a problem with spatial functions to a new custom schema.
I made a db, and following the PostGIS documentation I have created the
spatial extensions on it, but under the 'public' schema... How can I
create the spatial extensions on a custom schema?
Thanks a lot in advance
PS: English is not my native language, so excuse me for errors...
--
View this message in context:
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
18923897p18923897.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
BMT Cordah Ltd.
A member of the BMT group of companies
Registered Office: Investment House, 6 Union Row, Aberdeen AB10 1DQ
Registered in Scotland No. 163413
http://www.bmtcordah.com/
http://www.bmt.org/
The contents of this e-mail and any attachments are intended only for the use
of the e-mail addressee(s) shown. If you are not that person, or one of those
persons, you are not allowed to take any action based upon it or to copy it,
forward, distribute or disclose the contents of it and you should please delete
it from your system. BMT Cordah Limited does not accept liability for any
errors or omissions in the context of this e-mail or its attachments, which
arise as a result of Internet transmission, nor accept liability for statements
which are those of the author and not clearly made on behalf of BMT Cordah
Limited.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
