Thread: Comments on tables, functions, etc.

Comments on tables, functions, etc.

From
Michael Davis
Date:
How can I add a comment to a table, function, etc. that will should up in a
/dd comment in psql?


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

From
"Ross J. Reedstrom"
Date:
Michael -
I was just wondering this myself! I even dug into the source code, to
see if I could find how the comments get in there. Couldn't find any
existing SQL or psql command syntax, so I'm doing this:

template1=> \d pg_description

Table    = pg_description
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-------+
| objoid                           | oid
|     4 |
| description                      | text
|   var |
+----------------------------------+----------------------------------+-------+
Index:    pg_description_objoid_index
template1=> select oid from pg_class where relname = 'fred';
  oid
-----
66464
(1 row)

template1=> insert into pg_description values (66464,'This is the table
fred') ;

INSERT 66473 1
template1=> \dd fred
description
----------------------
This is the table fred
(1 row)

template1=>

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

--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

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

From
"jose' soares"
Date:
 

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)