Thread: Re: PATH for your scripts/SQL for psql

Re: PATH for your scripts/SQL for psql

From
Laurenz Albe
Date:
On Tue, 2025-05-20 at 10:49 +1200, Edwin UY wrote:
> 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
specifythe 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.

All you can do is use \cd:

  psql -c '\cd /some/where' -c '\i script.sql'

which is more complicated than specifying the full path, except if
you want to run several scripts with a single "psql" command.

Yours,
Laurenz Albe