psql command aliases support

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: pgsql-patches(at)postgresql(dot)org
Subject: psql command aliases support
Date: 2008-04-01 14:36:34
Message-ID: 81006C66CD7D9C5007325FD1@imhotep.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Attachment Content-Type Size
psql_aliases.patch text/x-diff 12.2 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Mathias Hasselmann 2008-04-01 15:07:31 Re: [HACKERS] Avahi support for Postgresql
Previous Message Albe Laurenz 2008-04-01 13:34:17 Improve shutdown during online backup