Обсуждение: Can you create aliases in the psql shell?

List,

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?

Cheers!
-Modulok-

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

>> 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

Thank you. This is perfect!

-Modulok-