Postgres Pro
Downloads
Home   >   mailing lists

How to extract table DDL from PGSQL database? - Mailing list pgsql-admin

From David Wagoner
Subject How to extract table DDL from PGSQL database?
Date
Msg-id C6F17AC15C94D84EBEB96A7B7D59D80603207710@MONALISA.arsenaldigital.com
Whole thread Raw
Responses Re: How to extract table DDL from PGSQL database?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Murthy Kambhampaty
Date:
Subject: Re: [PERFORM] backup/restore - another area.
Next
From: Tom Lane
Date:
Subject: Re: How to extract table DDL from PGSQL database?