Horton

Re: [GENERAL] Database Creation Script

Kevin Heflin <kheflin@shreve.net>

View thread View on postgr.es
From: Kevin Heflin <kheflin@shreve.net>
To: strawman@plexi.com
Cc: General Postgres List <pgsql-general@postgreSQL.org>
Date: 1999-02-23T15:55:43Z
Lists: 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
--------------------------------------------------------------------