【PostgreSQL】テーブルスペース・照合順序・イベントトリガーなどマイナーなオブジェクト一覧を確認する

testdb=# \db
      List of tablespaces
    Name    | Owner | Location
------------+-------+----------
 pg_default | postgres   |
 pg_global  | postgres   |
(2 rows)

testdb=# \db+
                                List of tablespaces
    Name    | Owner | Location | Access privileges | Options |  Size  | Description
------------+-------+----------+-------------------+---------+--------+-------------
 pg_default | postgres   |          |                   |         | 77 MB  |
 pg_global  | postgres   |          |                   |         | 560 kB |
(2 rows)

testdb=# CREATE COLLATION ja_ci (provider = icu, locale = 'ja-u-ks-level2');
testdb=# \dO
                              List of collations
 Schema | Name  |    Collate     |     Ctype      | Provider | Deterministic?
--------+-------+----------------+----------------+----------+----------------
 public | ja_ci | ja-u-ks-level2 | ja-u-ks-level2 | icu      | yes
(1 row)

testdb=# \dc *utf8*
                               List of conversions
   Schema   |          Name          |     Source     |  Destination   | Default?
------------+------------------------+----------------+----------------+----------
 pg_catalog | big5_to_utf8           | BIG5           | UTF8           | yes
 pg_catalog | euc_cn_to_utf8         | EUC_CN         | UTF8           | yes
 pg_catalog | euc_jis_2004_to_utf8   | EUC_JIS_2004   | UTF8           | yes
 pg_catalog | euc_jp_to_utf8         | EUC_JP         | UTF8           | yes
 ...
(N rows)

testdb=# SELECT lo_create(0);
 lo_create
-----------
     16806
(1 row)

testdb=# \dl
        Large objects
  ID   | Owner | Description
-------+-------+-------------
 16806 | postgres   |
(1 row)

testdb=# CREATE FUNCTION log_ddl() RETURNS event_trigger AS $$
testdb-# BEGIN RAISE NOTICE 'ddl command executed'; END;
testdb-# $$ LANGUAGE plpgsql;
testdb=# CREATE EVENT TRIGGER audit_ddl ON ddl_command_end EXECUTE FUNCTION log_ddl();
testdb=# \dy
                     List of event triggers
   Name    |      Event      | Owner | Enabled | Function | Tags
-----------+-----------------+-------+---------+----------+------
 audit_ddl | ddl_command_end | postgres   | enabled | log_ddl  |
(1 row)

testdb=# CREATE STATISTICS users_stat (dependencies) ON id, name FROM users;
NOTICE:  ddl command executed
CREATE STATISTICS

testdb=# CREATE STATISTICS users_stat (dependencies) ON id, name FROM users;
testdb=# ANALYZE users;
testdb=# \dX
                        List of extended statistics
 Schema |    Name    |     Definition      | Ndistinct | Dependencies | MCV
--------+------------+---------------------+-----------+--------------+-----
 public | users_stat | id, name FROM users |           | defined      |
(1 row)

testdb=# \dA
List of access methods
  Name  | Type
--------+-------
 brin   | Index
 btree  | Index
 gin    | Index
 gist   | Index
 hash   | Index
 heap   | Table
 spgist | Index
(7 rows)