From: | Bricklen Anderson <BAnderson(at)PresiNET(dot)com> |
---|---|
To: | "Casey T(dot) Deccio" <ctdecci(at)sandia(dot)gov> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Building a database from a flat file |
Date: | 2005-03-03 18:47:40 |
Message-ID: | 42275BCC.1050308@PresiNET.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Casey T. Deccio wrote:
> Question: is there an "easy" way to duplicate an existing schema
> (tables, functions, sequences, etc.)--not the data; only the schema?
> This way, I would only need to modify one schema (public) to make
> changes, and the build schema could be created each time as a duplicate
> of the public schema. Maintenance would be much simpler.
>
check the docs for pg_dump (-s) for doing structural dumps of your schema.
--
_______________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2005-03-03 19:30:27 | Re: Building a database from a flat file |
Previous Message | Markus Schaber | 2005-03-03 18:44:48 | Re: Building a database from a flat file |