shouldn't all tables have Object Descriptions?

Started by Geoffreyabout 18 years ago2 messagesgeneral
Jump to latest
#1Geoffrey
lists@serioustechnology.com

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

In reply to: Geoffrey (#1)
Re: shouldn't all tables have Object Descriptions?

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
---------------------------------------------------------------