[postgis-users] How to add spatial functions to a custom schema

[Mark Lidstone]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
gimbrogno
Sent: 11 August 2008 12:34
To: postgis-users at 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 at 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.