[postgis-devel] help

[Kevin Neufeld]

Hi Jhonys,
This is a development list.  Such questions might be more appropriate 
for the postgis-users list.

In any case, in response to your question, think of a schema as a 
directory or folder.  The public schema or folder, is really just like 
any other schema, except that it's named "public" and by default is 
available to everyone.

Just like when you create a new folder in Windows, (or any other OS for 
that matter), the folder is not automatically populated with all the 
data in an adjacent folder.  You would need to copy the data from one 
folder into another.

May I ask why you want to duplicate the contents of the public schema?  
You might be interested rather in postgresql's concept of a search_path 
[1]?  By issuing a statement like this
SET search_path TO xpto, public;
you would still be able to reference all your functions that live in the 
public schema.

Cheers,
Kevin

[1] 
http://www.postgresql.org/docs/8.4/static/ddl-schemas.html#DDL-SCHEMAS-PATH


On 5/17/2010 11:42 AM, Jhonys Correa Camacho wrote:
>
> Hi List!
>
> I would like to know how to create a new schema with all teh public 
> schema funcions and triggers,
> cause when i write this command :" create schema xpto;" the schema i 
> create come with no function e no triggers.
>
> Anyway thanks everybody.
>
> Jhonys
>
> ------------------------------------------------------------------------
> EM 2009 ACONTECERAM 250.362 FRAUDES NA INTERNET. CLIQUE PARA LER DICAS 
> DE SEGURANÇA. 
> <http://www.microsoft.com/brasil/windows/internet-explorer/features/navegue.aspx?tabid=1&catid=1&WT.mc_id=1565> 
>
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20100518/13c51c94/attachment.html>