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: (view raw, whole thread or download thread mbox)
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

also 'man pg_dump' will give you some info.


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 |

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-2017 The PostgreSQL Global Development Group