From: "Jim Buttafuoco" <jim@contactbda.com>
To: "Mark Fenbers" <Mark.Fenbers@noaa.gov>,
	Pg SQL Discussion Group <pgsql-sql@postgresql.org>
Reply-To: jim@contactbda.com
Subject: Re: Dumping table definitions
Date: Mon, 18 Jul 2005 12:56:35 -0400
Message-Id: <20050718165607.M86774@contactbda.com>
In-Reply-To: <42DBDDEE.3090903@noaa.gov>
References: <42DBDDEE.3090903@noaa.gov>
MIME-Version: 1.0
Content-Type: text/plain;
	charset=iso-8859-1


use pg_dump with the --schema-only and --table= params


---------- Original Message -----------
From: "Mark Fenbers" <Mark.Fenbers@noaa.gov>
To: Pg SQL Discussion Group <pgsql-sql@postgresql.org>
Sent: Mon, 18 Jul 2005 12:50:54 -0400
Subject: [SQL] Dumping table definitions

> I am looking for a way to reformat the information that is generated from
>     \d mytable
> into SQL syntax, such that the table can be recreated with 'psql -f 
> mytable.sql' complete with index and constraint definitions.  I can do 
> awk and sed commands to do this if I need to, but first wanted to check 
> if Pg already had tools to export the table structure (without the 
> data).  Does it?
> 
> Also, Is there a way to export the structure of all tables at once 
> instead of one table at a time?
> 
> Mark
------- End of Original Message -------