On 23-11-2013 19:25, brucedickinson@... wrote:

>
>
> Hi guys.
>
> I am thinking about writing an UDF function. This function needs to know
> the path to database regardless of the operating system. So it needs to
> know the path to database in Linux and Windows as well.
>
> I have no idea how to get programatically (in PSQL) path to a database.
> A context variable like CURRENT_DB_PATH would save my life, but I
> couldn't find anything like that in Firebird 2.5 language reference.

SELECT MON$DATABASE_NAME
FROM MON$DATABASE

I don't know if this is the actual filename, or the filename or alias
used to connect, so I suggest you try that.

Mark
--
Mark Rotteveel