| Subject | RE: Is there a way to tell the path to a firebird database in PSQL? |
|---|---|
| Author | |
| Post date | 2013-11-25T06:29:21Z |
Mark, thank you very much. I've lost hope that somebody answer this.
---In firebird-support@yahoogroups.com, <mark@...> wrote:On 23-11-2013 19:25, brucedickinson@... wrote:
>SELECT MON$DATABASE_NAME
>
> 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.
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