regdatabase

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>

To: pgsql-hackers@postgresql.org

Date: 2025-05-06T19:29:42Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add new OID alias type regdatabase.
- bd09f024a1bb 19 (unreleased) landed
pg_upgrade: Preserve database OIDs.
- aa01051418f1 15.0 cited

Every once in a while, I find myself wanting to use regdatabase for
something like current_database()::regdatabase, and I'm always surprised
when I inevitably rediscover that it doesn't exist.  I only found one
reference to the idea in the archives [0].  So, I have two questions:

* Is there an easier way to get the current database's (or any database's)
  OID that I am overlooking (besides "SELECT oid FROM pg_database...")?

* Would anyone object if I put together some patches to add regdatabase?

[0] https://postgr.es/m/20191109220939.jz55zcc33d3g7h7b%40alap3.anarazel.de

-- 
nathan