I have another question regarding this: It seems that you can attach a
description (or comment, as it is) to any oid. (Not with this command, but
in general). Is this restricted to system oids (like below 16000 or
whatever it was)? Otherwise comments on any user tuple could be created.
Perhaps this should be explicitly prevented or allowed. In the latter case
perhaps the comment statement could be tweaked. Not sure. Just wondering.
-Peter
On Oct 14, Mike Mascari mentioned:
> Hello Bruce,
>
> I've just submitted a patch to the patches list which
> implements Oracle's COMMENT statement. It will
> insert/update/delete the appropriate OID for the
> table or column targeted for the comment. It should
> apply cleanly against current. If it passes your
> scrutiny, I was wondering a couple of things:
>
> 1. Might it be possible for psql
> (a.k.a Peter Eisentraut) to display the comments
> associated with tables, views, and columns in
> its \d output? Or perhaps another \ command?
>
> 2. Should I write up SGML for it (as well as for
> TRUNCATE TABLE)?
>
> 3. Should I expand it beyond ORACLE's syntax to
> include functions, types, triggers, rules, etc.?
>
> On the TODO list its listed as:
>
> Allow pg_descriptions when creating types, tables,
> columns, and functions
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden