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