Re: Building a database from a flat file

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.
_______________________________

In response to

Browse pgsql-sql by date

  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