From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, alexey(dot)lesovsky(at)dataegret(dot)com
Subject: pg_get_databasebyid(oid)
Date: 2019-08-28 12:38:42
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

We already have function pg_get_userbyid(oid) with lookup in pg_authid catalog. My collegue ask me can we add similar function pg_get_databasebyid(oid) with lookup in pg_databases.
It is simple function to get a database name by oid and fallback to 'unknown (OID=n)' if missing.

The proposed patch is attached. Currently I missed the tests - I doubt which file in src/test/regress/sql/ is the most suitable. pg_get_userbyid is called from privileges.sql only.

regards, Sergei

Attachment Content-Type Size
v1_pg_get_databasebyid.patch text/x-diff 3.5 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Ibrar Ahmed 2019-08-28 12:49:40 Re: pg_get_databasebyid(oid)
Previous Message nilsocket 2019-08-28 12:16:03 Doubt regarding logical decoding