Re: [PROPOSAL] Make PSQLVAR on \getenv opitional

From: Matheus Alcantara <msalcantara(dot)dev(at)pm(dot)me>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PROPOSAL] Make PSQLVAR on \getenv opitional
Date: 2021-12-28 20:18:57
Message-ID: FBmlIdpuKVZ3s-VD_guW5nCD2TdkSgk8wnjpUHti8P6CmVSDF4Ue12KIcs22mp5W2x3tzCqw7GkEZoMiwevmOAhUY2qNfQSibXQjXrTZSys=@pm.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tuesday, December 28th, 2021 at 16:53, Tom Lanetgl(at)sss(dot)pgh(dot)pa(dot)us wrote:

> Matheus Alcantara msalcantara(dot)dev(at)pm(dot)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.)
>
> regards, tom lane

I definitely agree with this. We already have other ways to handle it.

Thanks for discussion and quick responses.

Matheus Alcantara

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2021-12-28 20:45:40 Re: [PROPOSAL] Make PSQLVAR on \getenv opitional
Previous Message Tom Lane 2021-12-28 20:10:57 Re: Foreign key joins revisited