Thread: psql table comments?

psql table comments?

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

cheers

andrew


Re: psql table comments?

From
Tom Lane
Date:
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


Re: psql table comments?

From
Andrew Dunstan
Date:

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