Thread: shouldn't all tables have Object Descriptions?

shouldn't all tables have Object Descriptions?

From
Geoffrey
Date:
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

Re: shouldn't all tables have Object Descriptions?

From
Raymond O'Donnell
Date:
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
---------------------------------------------------------------