Re: pg_get_databasebyid(oid)

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

CREATE OR REPLACE FUNCTION pg_get_databasebyid(dboid integer) RETURNS name AS $$

    SELECT datname from pg_database WHERE oid = dboid;