Re: [PROPOSAL] Make PSQLVAR on \getenv opitional

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matheus Alcantara <msalcantara(dot)dev(at)pm(dot)me>
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 19:53:14
Message-ID: 1916648.1640721194@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2021-12-28 19:56:55 Re: Foreign key joins revisited
Previous Message Adam Brusselback 2021-12-28 19:47:19 Re: Foreign key joins revisited