Обсуждение: PATH for your scripts/SQL for psql

Поиск
Список
Период
Сортировка

PATH for your scripts/SQL for psql

От
Edwin UY
Дата:
Hi,

Is there any settings that you can set for the PATH of your SQL/scripts so you don't have to cd where they are or specify the full path?
Kinda like the *nix PATH settings where you can PATH to it and you just run your command/scripts
FYI, I am NOT using psql on the database server.

Thanks.

Regards,
Ed

Re: PATH for your scripts/SQL for psql

От
"David G. Johnston"
Дата:
On Monday, May 19, 2025, Edwin UY <edwin.uy@gmail.com> wrote:
Hi,

Is there any settings that you can set for the PATH of your SQL/scripts so you don't have to cd where they are or specify the full path?
Kinda like the *nix PATH settings where you can PATH to it and you just run your command/scripts
FYI, I am NOT using psql on the database server.

Unable to test it right now but in Linux you should be able to add a shebang line at the top and make the file executable.  Then make sure it is in PATH.

David J.
 

Re: PATH for your scripts/SQL for psql

От
hubert depesz lubaczewski
Дата:
On Tue, May 20, 2025 at 10:49:33AM +1200, Edwin UY wrote:
> Hi,
> 
> Is there any settings that you can set for the PATH of your SQL/scripts so
> you don't have to cd where they are or specify the full path?
> Kinda like the *nix PATH settings where you can PATH to it and you just run
> your command/scripts
> FYI, I am NOT using psql on the database server.

No such thing exists, but please check if `\ir` isn't solving your
problem.

Best regards,

depesz