Re: Create Table Scripts

On Sat, 6 Jan 2001 chuckk@ext.usu.edu wrote:

> You know what I think would be pretty cool?  If someone out there would
> tell me that Postgresql can build "Create Table"  scripts by looking at
> an existing table.  Then I wouldn't have to re-create my Create Table
> scirpt  files I just incinerated....    Yeah... That would be cool if
> someone told me it could do that..

pg_dump -s <database>

will dump out scripts to build your database.  If you eliminate the -s, it
will also dump the data as insert statements.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
The light at the end of the tunnel may be an oncoming dragon.