From: Mario Splivalo <mario.splivalo@mobart.hr>
To: rsosnowski@cableone.net
Cc: pgsql-sql@postgresql.org
Subject: Re: Create Public Schema
Date: Sun, 20 Nov 2005 11:35:07 +0100
Message-ID: <1132482908.8298.0.camel@localhost.localdomain> (raw)
In-Reply-To: <1132455784_77546@S3.cableone.net>
References: <1132455784_77546@S3.cableone.net>
On Sat, 2005-11-19 at 20:03 -0700, rsosnowski@cableone.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mario.splivalo@mobart.hr, rsosnowski@cableone.net
Subject: Re: Create Public Schema
In-Reply-To: <1132482908.8298.0.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox