Re: [PATCH] Rename "getdatabaseencoding()" to "pg_database_encoding()", and document - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] Rename "getdatabaseencoding()" to "pg_database_encoding()", and document
Date
Msg-id 3880199.1784298573@sss.pgh.pa.us
Whole thread
In response to Re: [PATCH] Rename "getdatabaseencoding()" to "pg_database_encoding()", and document  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: [PATCH] Rename "getdatabaseencoding()" to "pg_database_encoding()", and document
List pgsql-hackers
Daniel Gustafsson <daniel@yesql.se> writes:
>> On 17 Jul 2026, at 08:44, Ian Lawrence Barwick <barwick@gmail.com> wrote:
>> It was noted here [1] that we have the undocumented SQL function
>> "getdatabaseencoding()", used mainly in regression tests and a couple
>> of psql queries. While considering a documentation patch, it occurred
>> to me that it's a horrible function name which doesn't look like other
>> public functions, and we already have "pg_client_encoding()", so why not
>> rename it to match that while we're at it?

> This function seems to be referred to in extensions, how about adding keeping
> the existin name and adding the new name as an alias?  It would keep existing
> code from breaking and cause less churn in the code.

Yeah, the odds that we would remove the old name (without a multi-year
deprecation period) are zero, full stop.

However, I can't really get excited about this proposal in the first
place.  There are plenty of ugly and inconsistent names in Postgres,
and an enormous amount of more-valuable work to do.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: Reduce cleanup lock contention on standby replay
Next
From: Tom Lane
Date:
Subject: Re: Deprecation warnings on Rocky 10.2 with current dev branch