Re: Dumping table definitions

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