ORDER BY in \dt+ ?

From: Fritz Lehmann-Grube <lehmannf(at)math(dot)TU-Berlin(dot)DE>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: ORDER BY in \dt+ ?
Date: 2002-02-01 12:32:54
Message-ID: 3C5A8AF6.565310BD@math.tu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Einar Karttunen 2002-02-01 12:37:51 Re: Name limit to 31 chars
Previous Message Mayan 2002-02-01 12:10:36 Creating a user