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

Mark Lidstone Mark.Lidstone at bmtcordah.com
Mon Aug 11 04:39:36 PDT 2008

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);


SELECT AddGeometryColumn('new_schema', 'table', 'field', 4326, 'POINT',


Mark Lidstone
Tel: +44 (0)23 80232222; Fax: +44 (0)23 80232891
BMT Cordah Ltd 
Grove House
7 Ocean Way
Ocean Village
SO14 3TJ

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
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:
Sent from the PostGIS - User mailing list archive at Nabble.com.

postgis-users mailing list
postgis-users at postgis.refractions.net

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

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.

More information about the postgis-users mailing list