ORDER BY in \dt+ ?

Поиск
Список
Период
Сортировка
От Fritz Lehmann-Grube
Тема ORDER BY in \dt+ ?
Дата
Msg-id 3C5A8AF6.565310BD@math.tu-berlin.de
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Arsalan Zaidi"
Дата:
Сообщение: Re:
Следующее
От: Einar Karttunen
Дата:
Сообщение: Re: Name limit to 31 chars