Andrew Dunstan escribió:
> What would be useful for many purposes, and is a long-standing
> project of mine that I still haven't found time to make progress on,
> is that the server should contain functions to produce the creation
> SQL for all its own objects, free of the locks that pg_dump requires
> for consistency.
Maybe you'd like my "DDL deparse" project, then. Right now it's only of
use for event triggers during DDL execution, but I don't see any strong
reason it cannot be used to reconstruct object creation commands from
only their identifying OID.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services