Consistent \d commands in psql
От | Greg Sabino Mullane |
---|---|
Тема | Consistent \d commands in psql |
Дата | |
Msg-id | 1194225113.7698.4.camel@greg-laptop обсуждение исходный текст |
Ответы |
Re: Consistent \d commands in psql
Re: Consistent \d commands in psql Re: Consistent \d commands in psql |
Список | pgsql-patches |
Attached is an updated version of my psql patch that makes the \d backslash commands perform in an intuitive, consistent way. Specifically, the following objects will be treated as first class citizens (as tables and indexes currently are) by showing all the non-system objects by default and requiring a "S" to see the system ones. aggregates conversions comments domains operators functions types Currently, there is no way to view all the non-system functions in a database using backslash commands, as you can with \dt, unless all of the functions happen to be in a single schema ("\df myschema."). With this patch, it would be as simple as "\df", and the current behavior would be done with "\dfS". This patch also adds a few new things to the tab-completion table, such as comments and conversions. Comments welcome. Last time the patch withered on the vine, despite strong support from -general, hence I'm going to try again, as I really want a way to view my functions without querying the pg_proc tables directly. :) -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200711042003 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
Вложения
В списке pgsql-patches по дате отправления: