Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Database Creation Script

From: Kevin Heflin <kheflin(at)shreve(dot)net>
To: strawman(at)plexi(dot)com
Cc: General Postgres List <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Database Creation Script
Date: 1999-02-23 15:55:43
Message-ID: Pine.LNX.4.02.9902230952320.5408-100000@mercury.shreve.net (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, 23 Feb 1999 strawman(at)plexi(dot)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(at)shreve(dot)net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------


In response to

pgsql-general by date

Next:From: James ThompsonDate: 1999-02-23 15:57:02
Subject: Re: [GENERAL] Database Creation Script
Previous:From: Jim MercerDate: 1999-02-23 15:39:44
Subject: Re: [GENERAL] Transaction logging

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group