Andrew Dunstan <[EMAIL PROTECTED]> writes: > What I would like to see is some builtin functions that give me the > table's DDL, just as pg_dump does. Extra nice would be complementary > functions that also give me skeleton select statements for each table or > view.
Yeah, what I first thought David was proposing was a consolidated view similar to pg_indexes, that could give you an up-to-date DDL definition for anything in the system. This has been proposed in the past as a way to migrate pg_dump functionality into the backend. I don't think it will actually work for that (pg_dump needs more understanding of what it's doing than just blindly copying complete CREATE commands) --- but it still seems potentially useful for manual operations. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match