Re: Can you create aliases in the psql shell? - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Can you create aliases in the psql shell?
Date
Msg-id 1360542770.82146.YahooMailNeo@web162906.mail.bf1.yahoo.com
Whole thread Raw
In response to Can you create aliases in the psql shell?  (Modulok <modulok@gmail.com>)
Responses Re: Can you create aliases in the psql shell?  (Modulok <modulok@gmail.com>)
List pgsql-general
Modulok <modulok@gmail.com> wrote:

> Is there a way to create command aliases in the psql shell? I can never

> remember all the \d* commands and have to look them up every time. If I
> could
> create things like \list_databases, \list_tables, \list_roles, etc,
> it would be
> much easier for me to remember.
>
> Is there a way to create such aliases? I'm using 9.2.3 if that matters. I
> didn't see anything in the man page. If not is there another command line
> client interface?

\set list_databases '\\l'

Then you can type :list_databases to get the same effect as \l

-Kevin

pgsql-general by date:

Previous
From: Modulok
Date:
Subject: Can you create aliases in the psql shell?
Next
From: Tim Uckun
Date:
Subject: Upsert Functionality using CTEs