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