Re: Can you create aliases in the psql shell?

Поиск
Список
Период
Сортировка
От Modulok
Тема Re: Can you create aliases in the psql shell?
Дата
Msg-id CAN2+EpYsiU3hKEiHpsLu-jjAVyxH-Jxi0mujc30aK+PrNpc_mw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can you create aliases in the psql shell?  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-general
>> 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-

В списке pgsql-general по дате отправления:

Предыдущее
От: Seref Arikan
Дата:
Сообщение: Re: What does Postgresql do when using CASE WHEN without ELSE?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: PG V9 on NFS