Re: [SQL] Create Public Schema

2005-11-20 Thread Mario Splivalo
On Sat, 2005-11-19 at 20:03 -0700, [EMAIL PROTECTED] wrote: > Hello all, > > I'm trying to create a schema that contains the default tables, > functions, etc. of the public schema. Using pgAdmin, when I create a > schema, it is blank - has no associated aggregates, tables, etc. How > would I cre

Re: [SQL] Create Public Schema

2005-11-20 Thread Andreas Kretschmer
[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb: > Hello all, > > I'm trying to create a schema that contains the default tables, functions, > etc. of the public schema. Using pgAdmin, when I create a schema, it is blank 1. make a dump from the public-schema 2. edit the dump and change 'public' t

[SQL] Create Public Schema

2005-11-19 Thread rsosnowski
Hello all, I'm trying to create a schema that contains the default tables, functions, etc. of the public schema.  Using pgAdmin, when I create a schema, it is blank - has no associated aggregates, tables, etc.  How would I create additional schems within a database that mirror the public schema.