From: | "Tefft, Michael J" <Michael(dot)J(dot)Tefft(at)snapon(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: [GENERAL] PostgreSQL counterpart to DBMS_METADATA? |
Date: | 2012-01-17 12:58:25 |
Message-ID: | 8C0087E93F6A9A459051869F5D574891884D8F@LISL-XBCK-C1-V2.snaponglobal.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Any suggestions for doing this from PL/pgSQL?
-----Original Message-----
From: depesz(at)depesz(dot)com [mailto:depesz(at)depesz(dot)com]
Sent: Tuesday, January 17, 2012 6:25 AM
To: Tefft, Michael J
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] PostgreSQL counterpart to DBMS_METADATA?
On Tue, Jan 17, 2012 at 04:53:42AM -0600, Tefft, Michael J wrote:
> I would like to extract the DDL to create a given object (tables,
> primarily) from the catalog. Is there an interface, query, etc. that
> will do this? I'd rather not craft the DDL myself.
use pg_dump -t table_name -s
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
From | Date | Subject | |
---|---|---|---|
Next Message | shitake | 2012-01-17 14:07:31 | Upgrade Postgres 8.4SS >> 9.1 |
Previous Message | Tom Molesworth | 2012-01-17 11:33:39 | Re: Whats the most efficient query for this result? |