Thread: table oids and comments
Hello: I think I'm a little confused about the something in the documentation: - I think table oids have been deprecated (http://www.postgresql.org/docs/8.2/interactive/runtime-config-compatible.html) - It looks like the only way to retrieve the comments associated with a table is to use the function obj_descritption(object_oid, catalog_name). (http://www.postgresql.org/docs/8.2/interactive/functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE) Is this a different oid? Thanks for the help! Mija
Mija Lee wrote: > I think I'm a little confused about the something in the documentation: > > - I think table oids have been deprecated > (http://www.postgresql.org/docs/8.2/interactive/runtime-config-compatible.html) > > - It looks like the only way to retrieve the comments associated with a > table is to use the function obj_descritption(object_oid, catalog_name). > (http://www.postgresql.org/docs/8.2/interactive/functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE) > > Is this a different oid? 17.12: The use of OIDs in user tables is considered deprecated 9.19: System Information Functions System functions access system tables; they do not access user tables.
Mija Lee wrote: > > I think I'm a little confused about the something in the documentation: > > - I think table oids have been deprecated > (http://www.postgresql.org/docs/8.2/interactive/runtime-config-compatible.html) > Use of OIDs in *user* tables is deprecated. OIDs *are* used by the *system* tables. > - It looks like the only way to retrieve the comments associated with > a table is to use the function obj_descritption(object_oid, > catalog_name). > (http://www.postgresql.org/docs/8.2/interactive/functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE) > > These are system tables. You can leave OIDs set to off for user tables and still have comments. Cheers, Steve