Any suggestions for doing this from PL/pgSQL?
-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Tuesday, January 17, 2012 6:25 AM
To: Tefft, Michael J
Cc: [email protected]
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/
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
