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