DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=afeQVk0SZ+TGpfbh/XHQS7m8jsv3v74mZlD0cbO8PypVlwIxlS1P7OA0wjHe5DYNI5qw1+TljWjrTwiugwBptuxNW0V1rDuGHUa48X+7DwjCeecxhLuDhCerJFQHdfHJyJcylhfzRXKXTY0uWeiyX19quXr9tsPINm3HP8MCqGI=
Message-ID: <758d5e7f0507181008403969ec@mail.gmail.com>
Date: Mon, 18 Jul 2005 19:08:56 +0200
From: Dawid Kuroczko <qnex42@gmail.com>
Reply-To: Dawid Kuroczko <qnex42@gmail.com>
To: Mark Fenbers <Mark.Fenbers@noaa.gov>
Subject: Re: Dumping table definitions
Cc: Pg SQL Discussion Group <pgsql-sql@postgresql.org>
In-Reply-To: <42DBDDEE.3090903@noaa.gov>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <42DBDDEE.3090903@noaa.gov>

On 7/18/05, Mark Fenbers <Mark.Fenbers@noaa.gov> wrote:
> 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?

pg_dump is your friend!  Use option -s (--schema-only).
It will dump the information you want. :-)

  Regards,
    Dawid