Re: Getting my Database name in a C Extension

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cedric Berger <cedric(at)precidata(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting my Database name in a C Extension
Date: 2014-10-02 16:13:33
Message-ID: 29376.1412266413@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Cedric Berger <cedric(at)precidata(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Néstor Boscán 2014-10-02 16:15:46 Creating a PL/pgSQL function that returns multiple out parameters and refcursor
Previous Message Cedric Berger 2014-10-02 15:38:27 Getting my Database name in a C Extension