Re: [PROPOSAL] Make PSQLVAR on \getenv opitional - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: [PROPOSAL] Make PSQLVAR on \getenv opitional
Date
Msg-id a58c208c-4828-abe7-dde2-ec4a9a19da61@dunslane.net
Whole thread Raw
In response to Re: [PROPOSAL] Make PSQLVAR on \getenv opitional  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Matheus Alcantara
Date:
Subject: Re: [PROPOSAL] Make PSQLVAR on \getenv opitional
Next
From: Alvaro Herrera
Date:
Subject: Re: Column Filtering in Logical Replication