Re: [NOVICE] table oids and comments

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

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice