On Sun, Feb 21, 2021, at 8:15 PM, Vik Fearing wrote:
> and a second patch that adds a read-only guc to get at it on the SQL
> level using SHOW catalog_version; or similar.  I need that because I
> also do a dump of pg_settings and I would like for it to appear there.
The catalog version number is already available in pg_control_system().

postgres=# select * from pg_control_system();
-[ RECORD 1 ]------------+-----------------------
pg_control_version       | 1300
catalog_version_no       | 202007201
system_identifier        | 6931867587550812316
pg_control_last_modified | 2021-02-21 20:59:06-03


--
Euler Taveira
EDB   https://www.enterprisedb.com/

Reply via email to