Michael Tefft <mjtefft@xxxxxxxxxxx> writes: > 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. DDL isn't actually stored in the catalogs anywhere; it has to be reconstructed. The only complete solution to that problem is embodied in pg_dump. Hence the short answer is "extract what you need from pg_dump output". Depending on exactly what you need, you might be able to get pg_dump to emit only the object definition(s) you want in the first place. Another possibility that wouldn't involve editing a large dump file is to dump to an archive file and then use pg_restore's -l and -L options to obtain a customized selective restore script. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
