| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
--------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Thompson | 1999-02-23 15:57:02 | Re: [GENERAL] Database Creation Script |
| Previous Message | Jim Mercer | 1999-02-23 15:39:44 | Re: [GENERAL] Transaction logging |