Re: Can you create aliases in the psql shell?

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