Re: Getting my Database name in a C Extension - Mailing list pgsql-general

From Tom Lane
Subject Re: Getting my Database name in a C Extension
Date
Msg-id 29376.1412266413@sss.pgh.pa.us
Whole thread Raw
In response to Getting my Database name in a C Extension  (Cedric Berger <cedric@precidata.com>)
Responses Re: Getting my Database name in a C Extension  (Cedric Berger <cedric@precidata.com>)
List pgsql-general
Cedric Berger <cedric@precidata.com> writes:
> I'm writing an extention (FDW), and I need, in my C code, the name of
> my database ("contrib_regression_test" for example), and I've two
> questions:

> 1) What is the easiest way to get that directly in C?

The usual locution is "get_database_name(MyDatabaseId)".

> 2) Is there a way to get this information in the SQL extension
> installation/update scripts (like the @/extschema/@ substitution)?

Nope.  Doesn't seem to me like a remarkably good idea to refer to it
in that sort of way anyway.  What would happen if someone renamed
the database after the extension is installed?

            regards, tom lane


pgsql-general by date:

Previous
From: Cedric Berger
Date:
Subject: Getting my Database name in a C Extension
Next
From: Néstor Boscán
Date:
Subject: Creating a PL/pgSQL function that returns multiple out parameters and refcursor