Tracking: support pgAdmin 4

[lmatz]

Actions to test:

• connect to RisingWave server
• list all databases
• list all schemas inside a database (current progress branch)
• list all tables inside a schema

Issues:

• [ ] #11048
• [x] #11146
• [x] #11160
• [x] #11181
• [x] #11202
• system functions
  • pg_is_in_recovery() -> false
  • pg_is_wal_replay_paused() -> false
  • has_schema_privilege
  • has_table_privilege
  • aclexplode (setof record)
• session configs
  • lc_collate -> C
  • lc_ctype -> C
  • default_tablespace -> empty string
• pg_catalog
  • pg_user.usename
  • pg_database.oid expected to be > 16383
  • workaround: enable show system objects and show template databases in pgAdmin, and create a new database in RisingWave other than dev
  • pg_shseclabel
  • pg_default_acl
  • pg_db_role_setting
• Warning on version older than PostgreSQL 10
• CAST( AS oid)

• 11292

[xiangjinwu]

Pausing the effort in favor of DBeaver. There are numerous dependencies on pg internal catalogs and functions for each click #2954. We'd better focus on one tool first.