Thread: Retrieve filename within a script

On 11/14/24 00:42, Patrick FICHE wrote:
> Hi,
> 
> I was wondering if it was possible to get the filename provided as an 
> argument to psql.

Not that I know of.

> 
> psql -f /tmp/test.sql
> 
> I would like a command in test.sql that would be able to retrieve the 
> full pathname (/tmp/test.sql).
> 
> Regards,
> 
> Patrick
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

On Thu, 14 Nov 2024 08:42:36 +0000
Patrick FICHE <Patrick.Fiche@aqsacom.com> wrote:

> I was wondering if it was possible to get the filename provided as an argument to psql.
> psql -f /tmp/test.sql
>

Since you know it already, you could pass it as a variable :

psql -f /tmp/test.sql -v my_path='/tmp/test.sql'

and retrieve it with SELECT :'my_path';

--
                    Bien à vous, Vincent Veyron

https://marica.fr
Logiciel de gestion des contentieux juridiques, des contrats et des sinistres d'assurance