psql table comments?

Started by Andrew Dunstanover 21 years ago3 messages
#1Andrew Dunstan
andrew@dunslane.net

I have just noticed that \d+ tablename doesn't show the table
comment/description - should it? Is this a TODO?

cheers

andrew

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Andrew Dunstan (#1)
Re: psql table comments?

Andrew Dunstan <andrew@dunslane.net> writes:

I have just noticed that \d+ tablename doesn't show the table
comment/description - should it? Is this a TODO?

\dt+ tablename shows this, in what is probably a more convenient format
than \d+ would be able to use. The \d printout is already awfully
cluttered, I don't think we want to add stuff to it unnecessarily.

regards, tom lane

#3Andrew Dunstan
andrew@dunslane.net
In reply to: Tom Lane (#2)
Re: psql table comments?

Tom Lane wrote:

Andrew Dunstan <andrew@dunslane.net> writes:

I have just noticed that \d+ tablename doesn't show the table
comment/description - should it? Is this a TODO?

\dt+ tablename shows this, in what is probably a more convenient format
than \d+ would be able to use.

Not if you like to use multiline table comments like I do.

no biggie - I can live without it.

cheers

andrew