shouldn't all tables have Object Descriptions?
We've stumbled upon an issue that we don't understand. I'm assuming
that any given table should contain 'Object Descriptions.' For example,
we have two tables as follows:
mwv=# \dd carr;
Object descriptions
Schema | Name | Object | Description
--------+------+--------+--------------
public | carr | table | Carrier File
(1 row)
mwv=# \dd avlds;
Object descriptions
Schema | Name | Object | Description
--------+------+--------+-------------
(0 rows)
Question is, why does the avlds table not have an entry in the Object
descriptions?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
On 25/01/2008 19:54, Geoffrey wrote:
Question is, why does the avlds table not have an entry in the Object
descriptions?
According to \? in psql, \dd shows the comment on the table....so I
suppose if there's no comment, then \dd won't show one.
Comments are created by executing
COMMENT ON TABLE yourtablename IS '....comment here....';
There's no comment created by default.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------