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

[gimbrogno]

Thanks a lot... now it goes!



Obe, Regina     DND\MIS wrote:
> 
> Gimbrogno,
> Do the following before running the .sql files.
> 
> SET search_path = info;
> 
> Keep in mind that you should really only have those functions and table
> loaded in one schema not all of them even if you have your tables in
> different schemas.  The functions and tables should exist only once per
> database.
> 
> You will also want to add the info schema to your database search path,
> otherwise many things and software that works with PostGIS will not work
> since they don't prefix the schema name.
> 
> So to do that you would do something like this
> 
> ALTER DATABASE your_database_name_here SET search_path="$user", public,
> info;
> 
> 
> Hope that helps,
> Regina
>  
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> gimbrogno
> Sent: Monday, August 11, 2008 7:51 AM
> To: postgis-users at postgis.refractions.net
> Subject: RE: [postgis-users] How to add spatial functions to a custom
> schema
> 
> 
> Hi, thanks for your answer but it is not my problem...
> 
> I have to create spatial functions under a schema called 'info', and If
> I
> use psql -d myDb -f lwpostgis.sql, the spatial functions are created
> under
> the schema 'public'!
> 
> How Can I make spatial function under schema 'info' ?
> 
> Thanks a lot in advance...
> 
> Mark Lidstone wrote:
>> 
>> 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.
>> 
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> 
>> 
> 
> -- 
> View this message in context:
> http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
> 18923897p18924157.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
> -----------------------------------------
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure
> pursuant to Massachusetts law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and delete the material from any computer.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp18923897p18925804.html
Sent from the PostGIS - User mailing list archive at Nabble.com.