ORDER BY in \dt+ ? - Mailing list pgsql-general

From Fritz Lehmann-Grube
Subject ORDER BY in \dt+ ?
Date
Msg-id 3C5A8AF6.565310BD@math.tu-berlin.de
Whole thread Raw
List pgsql-general
Hallo All,

I'd like to have the output of a \dt+ command ordered.
Is there a ( badly documented ) option like \pset listingorder=... ?
Or do I have to rewrite it like
   SELECT * FROM pg_tables WHERE ... ORDER BY oid;

If so, how do I get the comments ? As far as I can see, they are not
stored in pg_tables - where else ?

Another question is about comments on columns. I can create one, but
cannot get it afterwards. I did:

arbeitsdb04=# comment on column sections.final is 'Hallo final';
COMMENT
arbeitsdb04=# \dd sections.final
     Object descriptions
 Name | Object | Description
------+--------+-------------
(0 rows)

So where is that comment ?

Thanx and Greetings  Fritz

pgsql-general by date:

Previous
From: "Arsalan Zaidi"
Date:
Subject: Re:
Next
From: Einar Karttunen
Date:
Subject: Re: Name limit to 31 chars