Search Postgresql Archives

Re: Can you create aliases in the psql shell?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux