Request a Demo
Home   >   mailing lists

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

From David G. Johnston
Subject Re: PATH for your scripts/SQL for psql
Date
Msg-id CAKFQuwa2ELtLb3bWwO_v_rX0tPjkcpg+=1e0Sg3TwQDN3Z5e9A@mail.gmail.com
Whole thread Raw
In response to PATH for your scripts/SQL for psql  (Edwin UY <edwin.uy@gmail.com>)
List pgsql-admin
Tree view
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.
 

pgsql-admin by date:

Previous
From: Edwin UY
Date:
Subject: PATH for your scripts/SQL for psql
Next
From: Laurenz Albe
Date:
Subject: Re: PATH for your scripts/SQL for psql