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
--------------------------------------------------------------------