Re: [GENERAL] Database Creation Script - Mailing list pgsql-general

From Kevin Heflin
Subject Re: [GENERAL] Database Creation Script
Date
Msg-id Pine.LNX.4.02.9902230952320.5408-100000@mercury.shreve.net
Whole thread Raw
In response to Database Creation Script  (strawman@plexi.com)
List pgsql-general
On Tue, 23 Feb 1999 strawman@plexi.com wrote:

> How do I generate a database creation script for an existing database?
>
> What's the best documentation available for postgresql?
>
> Please forgive the newbie questions.


I've used from the command line:

pg_dump dbname -f filename -z -v

to create the sql creation scripts as well as the data.


I believe I originally found this in the documentation available at
http://www.postgresql.org

also 'man pg_dump' will give you some info.

Kevin



--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------


pgsql-general by date:

Previous
From: Bas Peters
Date:
Subject: indexing functions
Next
From: James Thompson
Date:
Subject: Re: [GENERAL] Database Creation Script