SELECT * FROM pg_available_extensions;
postgres=# SELECT * FROM pg_available_extensions; name | default_version | installed_version | comment ---------+-----------------+-------------------+------------------------------ plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language (1 row)