| 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: | Whole Thread | Raw Message | 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 |