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@xxxxxx --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match