sql: pgadmin support

[knz]

• [x] #20782 sql: support bytea_output session variable
• [x] #26374 sql: add pg_is_in_recovery()
• [x] #26376 sql: add pg_shdescription
• [x] #26378 sql: add pg_default_acl
• [x] #26379 sql: add pg_shseclabel
• [x] #26380 sql: add pg_encoding_to_char()
• [x] #26384 sql: add pg_is_xlog_reply_paused()
• [x] #26386 sql: add current_setting()
• [x] #26389 sql: add pg_shdepend
• [x] #26390 sql: add pg_conversion
• [ ] #26392 sql: add pg_tablespace_size()
• [ ] #26398 sql: add pg_database_size()
• [x] #26399 sql: add pg_stat_database
• [x] #26400 sql: add pg_stat_database_conflicts
• [x] #26404 sql: add pg_stat_replication
• [x] #26584 sql: support pgadmin's schema creation SQL pretty-printer
• [x] #26409 sql: support default_tablespace
• [x] #26515 sql: add pg_catalog.pg_seclabel and pg_catalog.pg_shseclabel
• [ ] #3781 (at least the timestamptz ones)
• [ ] #91070
• [x] #91073
• [x] #91068
• [ ] #91113
• [ ] #91114
• [ ] #91115

An unfortunate new problem is that pgadmin has a hardcoded "last system OID" defined as 16383: https://github.com/pgadmin-org/pgadmin4/blob/master/web/pgadmin/utils/constants.py#L118

This constant is used as a filter to exclude databases and possibly other objects with IDs less than that number. There's no way that we can really configure this aside from forking pgadmin, and it doesn't fetch the number by querying the server, so we're a little stuck there.

List of issues encountered when running PGAdmin's test suite: #26603

Epic CRDB-2462

Jira issue: CRDB-5723

[knz]

cc @awoods187 we'll look into this soon then

[codenoid]

hi, is there any update on this? It's almost 2024

[debankanmitra]

eagerly waiting for an update...