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
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 |