Re: [PROPOSAL] Make PSQLVAR on \getenv opitional

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: [PROPOSAL] Make PSQLVAR on \getenv opitional
Дата
Msg-id a58c208c-4828-abe7-dde2-ec4a9a19da61@dunslane.net
обсуждение исходный текст
Ответ на Re: [PROPOSAL] Make PSQLVAR on \getenv opitional  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 12/28/21 14:53, Tom Lane wrote:
> Matheus Alcantara <msalcantara.dev@pm.me> writes:
>>> it is not consistent with other \g* commands. Maybe a new statement \senv ? But what is the use case? You can just
press^z and inside shell write echo $xxx, and then fg
 
>> I think that the basic use case would be just for debugging, instead call \getenv and them \echo, we could just use
\getenv.I don't see any other advantages, It would just be to
 
>> write fewer commands. I think that ^z and then fg is a good alternative, since this behavior would be inconsistent.
> You don't even need to do that much.  This works fine:
>
> postgres=# \! echo $PATH
>
> So I'm not convinced that we need another way to spell that.
> (Admittedly, this probably doesn't work on Windows, but
> I gather that environment variables are less interesting there.)
>
>             


I haven't tested, but I'm fairly sure

    postgres=# \! echo %PATH%

would do the trick on Windows.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com




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

Предыдущее
От: Matheus Alcantara
Дата:
Сообщение: Re: [PROPOSAL] Make PSQLVAR on \getenv opitional
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Column Filtering in Logical Replication