Yes for the love of god do it :D David Fetter wrote:
Folks,Before I dive into this, is there some reason why the pg_catalog.* tables/views should not have comments that match the descriptions in the docs? I can see where this could cause some maintenance issues, and those probably need to be addressed, but it sure would be nice if \d+ pg_depend pulled up something like: Table "pg_catalog.pg_depend" Column | Type | Modifiers | Description -------------+---------+-----------+------------- classid | oid | not null | The OID of the system catalog the dependent object is in objid | oid | not null | The OID of the specific dependent object objsubid | integer | not null | For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero. refclassid | oid | not null | The OID of the system catalog the referenced object is in refobjid | oid | not null | The OID of the specific referenced object refobjsubid | integer | not null | For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero. deptype | "char" | not null | A code defining the specific semantics of this dependency relationship; see text. Cheers, D
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
