Well if you do a pg_dump databasename > somefile
your table specs, among other things, will be in somefile
eric
----- Original Message -----
From: <chuckk@ext.usu.edu>
To: <pgsql-novice@postgresql.org>
Sent: Saturday, January 06, 2001 9:24 AM
Subject: Create Table Scripts
> 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..
>
> sigh.....
>
>
> Chuck
>
>