Message-ID: <42DBDDEE.3090903@noaa.gov>
Date: Mon, 18 Jul 2005 12:50:54 -0400
From: "Mark Fenbers" <Mark.Fenbers@noaa.gov>
Organization: DoC/NOAA/NWS/OHRFC
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
MIME-Version: 1.0
To: Pg SQL Discussion Group <pgsql-sql@postgresql.org>
Subject: Dumping table definitions
Content-Type: multipart/mixed; boundary="------------040503060204070609080604"

This is a multi-part message in MIME format.
--------------040503060204070609080604
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------040503060204070609080604
Content-Type: text/x-vcard; charset=utf-8;
 name="Mark.Fenbers.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="Mark.Fenbers.vcf"

begin:vcard
fn:Mark Fenbers
n:Fenbers;Mark
org:DoC/NOAA/NWS/OHRFC
adr:;;1901 South SR 134;Wilmington;OH;45177-9708;USA
email;internet:Mark.Fenbers@noaa.gov
title:Sr. HAS Meteorologist
tel;work:937-383-0430 x246
x-mozilla-html:TRUE
url:http://weather.gov/ohrfc
version:2.1
end:vcard


--------------040503060204070609080604--