psql command aliases support

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема psql command aliases support
Дата
Msg-id 81006C66CD7D9C5007325FD1@imhotep.credativ.de
обсуждение исходный текст
Ответы Re: psql command aliases support  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: psql command aliases support  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Folks,

please find attached a patch which implements psql command aliases. They
work the same way as on bash, zsh and others, for example:

#= \alias d \dt+
#= \d
              List of relations
 Schema | Name | Type  | Owner | Description
--------+------+-------+-------+-------------
 public | foo  | table | bernd |
(1 row)

=# \alias current_query SELECT current_query, NOW() - query_start FROM
pg_stat_activity WHERE current_query NOT LIKE 'IDLE%';

#= \current_query
                                             current_query
| ?column?
-------------------------------------------------------------------------------------------------------+----------
 SELECT current_query, NOW() - query_start FROM pg_stat_activity WHERE
current_query NOT LIKE 'IDLE%'; | 00:00:00
(1 row)


#= \unalias d
#= \d
       List of relations
 Schema | Name | Type  | Owner
--------+------+-------+-------
 public | foo  | table | bernd
(1 row)


I hope i broke nothing and maybe we find this useful for 8.4, documentation
included.

--
  Thanks

                    Bernd

Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Improve shutdown during online backup
Следующее
От: Mathias Hasselmann
Дата:
Сообщение: Re: [HACKERS] Avahi support for Postgresql