PostgreSQL で extension のバージョンを確認する方法のメモ。
pg_available_extensions テーブルでバージョンを確認することができます。
# select * from pg_available_extensions;
name | default_version | installed_version | comment
--------------------+-----------------+-------------------+----------------------------------------------------------------
pageinspect | 1.12 | | inspect the contents of database pages at a low level
plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language
...
xml2 | 1.1 | | XPath querying and XSLT
vector | 0.8.0 | | vector data type and ivfflat and hnsw access methods
hstore_plpython3u | 1.0 | | transform between hstore and plpython3u
jsonb_plpython3u | 1.0 | | transform between jsonb and plpython3u
plpython3u | 1.0 | | PL/Python3U untrusted procedural language
textsearch_ja | 42 | 42 | Integrated Full-Text-Search for Japanese using morphological an
ltree_plpython3u | 1.0 | | transform between ltree and plpython3u
