On 23-11-2013 19:25, [email protected] 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
