Re: PATH for your scripts/SQL for psql - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: PATH for your scripts/SQL for psql
Date
Msg-id 2bb15798dd91b4ae09e578d360aa5cb57cc47173.camel@cybertec.at
Whole thread Raw
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: PostgreSQL Load Testing
Next
From: zaidagilist
Date:
Subject: Re: PostgreSQL Load Testing