Re: pg_get_databasebyid(oid)

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, alexey(dot)lesovsky(at)dataegret(dot)com
Subject: Re: pg_get_databasebyid(oid)
Date: 2019-08-29 10:16:25
Message-ID: 51165371567073785@myt5-b646bde4b8f3.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

> Is there a need for this function for the user?

This was feature request from user. I got such comment:

This function is useful when working with pg_stat_statements. For obtaining a databаse name for particular query you need to join pg_database relation, but for obtaining an username you just need pg_get_userbyid(). So it will be useful not to join extra relation and get a database name using the similar function - pg_get_databasebyid().

regards, Sergei

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ibrar Ahmed 2019-08-29 10:47:40 Re: pg_get_databasebyid(oid)
Previous Message Jeevan Ladhe 2019-08-29 09:47:31 Re: basebackup.c's sendFile() ignores read errors