Michael Davis ha scritto:
How can I add a comment to a table, function, etc. that will should up in apg_description has two fields...
/dd comment in psql?
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)
