<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Jhonys, <br>
This is a development list. Such questions might be more appropriate
for the postgis-users list.<br>
<br>
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.<br>
<br>
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.<br>
<br>
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<br>
SET search_path TO xpto, public;<br>
you would still be able to reference all your functions that live in
the public schema.<br>
<br>
Cheers,<br>
Kevin<br>
<br>
[1]
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.4/static/ddl-schemas.html#DDL-SCHEMAS-PATH">http://www.postgresql.org/docs/8.4/static/ddl-schemas.html#DDL-SCHEMAS-PATH</a><br>
<br>
<br>
On 5/17/2010 11:42 AM, Jhonys Correa Camacho wrote:
<blockquote cite="mid:SNT108-W4648357AF79C460FECDB5091E00@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style><br>
Hi List!<br>
<br>
I would like to know how to create a new schema with all teh public
schema funcions and triggers,<br>
cause when i write this command :" create schema xpto;" the schema i
create come with no function e no triggers.<br>
<br>
Anyway thanks everybody.<br>
<br>
Jhonys<br>
<br>
<hr>EM 2009 ACONTECERAM 250.362 FRAUDES NA INTERNET. <a
moz-do-not-send="true"
href="http://www.microsoft.com/brasil/windows/internet-explorer/features/navegue.aspx?tabid=1&catid=1&WT.mc_id=1565"
target="_new">CLIQUE PARA LER DICAS DE SEGURANÇA.</a>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
postgis-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-devel">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a>
</pre>
</blockquote>
</body>
</html>