| From: | Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> |
|---|---|
| To: | rsosnowski(at)cableone(dot)net |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Create Public Schema |
| Date: | 2005-11-20 10:35:07 |
| Message-ID: | 1132482908.8298.0.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Sat, 2005-11-19 at 20:03 -0700, rsosnowski(at)cableone(dot)net 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 create additional schems within a database that mirror the
> public schema.
>
I guess your best bet would be to manually create all the scripts for
your database/schema objects. Use pg_dump to create a 'database schema
snapshot', and then use pg_restore -L to create scripts for objects you
desire.
Mike
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2005-11-20 11:07:00 | Re: Is it possible to redirect an update/insert/delete to a different table? |
| Previous Message | Joost Kraaijeveld | 2005-11-20 09:18:00 | Trigger / rule question |