How to extract table DDL from PGSQL database?

From: David Wagoner <dwagoner(at)arsenaldigital(dot)com>
To: "PGSQL List (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: How to extract table DDL from PGSQL database?
Date: 2003-10-17 18:18:29
Message-ID: C6F17AC15C94D84EBEB96A7B7D59D80603207710@MONALISA.arsenaldigital.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

How do I extract table or view DDL from a postgresql database? I thought
the PGAdmin tool would do this, but I haven't found the functionality there
yet. Looked at the system catalog tables, but didn't find everything I
needed (version 7.1 postgresql). Anyone have a script or know of a tool?

Thanks.

Best regards,

David B. Wagoner
Database Administrator

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-10-17 19:02:36 Re: How to extract table DDL from PGSQL database?
Previous Message Murthy Kambhampaty 2003-10-17 17:33:36 Re: [PERFORM] backup/restore - another area.