Re: How to get the name of the current database in C function/extention inside a trigger?

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: alex m <al-gen(at)serendipia(dot)email>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to get the name of the current database in C function/extention inside a trigger?
Date: 2020-08-03 10:34:29
Message-ID: CAApHDvr0uvSiSNt814sm8WDBPC_R+_sh8gRUytWRk9CnAG=--Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 3 Aug 2020 at 21:26, alex m <al-gen(at)serendipia(dot)email> wrote:
> I'm writting a function/extention in C for a trigger. Inside a trigger, in C, I want to get the name of the current database. However, not via SPI_exec(), SPI_prepare() and the like, but more directly, in a more faster way.

You can use MyDatabaseId in miscadmin.h

If you git grep MyDatabaseId in src/contrib you can see some examples.

A good tip for the future would be to just look at the source code of
the built-in function and see how it does it.

David

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Ashmead 2020-08-03 14:38:42 How can you find out what point logical replication is at?
Previous Message Daniel Westermann (DWE) 2020-08-03 09:37:48 Re: Out of memory with "create extension postgis"