Re: [GENERAL] Comments on tables, functions, etc.

Michael Davis ha scritto:

> How can I add a comment to a table, function, etc. that will should up in a
> /dd comment in psql?

pg_description has two fields...

joe=> \d pg_description

Table = pg_description
+----------------------------------+----------------------------------+-------+

| Field | Type | Length|

+----------------------------------+----------------------------------+-------+

| objoid | oid | 4 |

| description | text | var |

+----------------------------------+----------------------------------+-------+

To add your own description you have to know the oid of your table,function,
etc
and then assign this valuo to pg_description.objoid and your description to
pg_description.description.
Take a look:

joe=> select relname,oid from pg_class where relname='btmm';
relname| oid
-------+------
btmm |190177
(1 row)

joe=> \dd btmm
description
--------------
no description
(1 row)

joe=> insert into pg_description values(190177,'a minha tabela');
INSERT 226304 1

joe=> \dd btmm
description
--------------
a minha tabela
(1 row)

--
- Jose' -

"No other success in life can compensate for failure in the home" (David O.
McKay)