PostgreSQL

 追加提供モジュールについて

pg_extension 追加モジュールに関する情報出力

現在追加されているモジュール一覧出力SQL
select * from pg_extension order by extname;
  oid  |   extname    | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-------+--------------+----------+--------------+----------------+------------+-----------+--------------
 16520 | dblink       |       10 |         2200 | t              | 1.2        |           |
 14370 | plpgsql      |       10 |           11 | f              | 1.0        |           |
 16580 | postgres_fdw |       10 |         2200 | t              | 1.0        |           |
(3 rows)


myposdb=#

pg_stat_statements

追加可能なモジュール一覧出力SQL

installed_versionカラムに値が設定されているものは追加されているモジュールです。

select * from pg_available_extensions
order by installed_version,name;
        name        | default_version | installed_version |                                comment
--------------------+-----------------+-------------------+------------------------------------------------------------------------
 plpgsql            | 1.0             | 1.0               | PL/pgSQL procedural language
 postgres_fdw       | 1.0             | 1.0               | foreign-data wrapper for remote PostgreSQL servers
 dblink             | 1.2             | 1.2               | connect to other PostgreSQL databases from within a database
 adminpack          | 2.1             |                   | administrative functions for PostgreSQL
 amcheck            | 1.2             |                   | functions for verifying relation integrity
 autoinc            | 1.0             |                   | functions for autoincrementing fields
 bloom              | 1.0             |                   | bloom access method - signature file based index
 btree_gin          | 1.3             |                   | support for indexing common datatypes in GIN
 btree_gist         | 1.5             |                   | support for indexing common datatypes in GiST
 citext             | 1.6             |                   | data type for case-insensitive character strings
 cube               | 1.4             |                   | data type for multidimensional cubes
 dict_int           | 1.0             |                   | text search dictionary template for integers
 dict_xsyn          | 1.0             |                   | text search dictionary template for extended synonym processing
 earthdistance      | 1.1             |                   | calculate great-circle distances on the surface of the Earth
 file_fdw           | 1.0             |                   | foreign-data wrapper for flat file access
 fuzzystrmatch      | 1.1             |                   | determine similarities and distance between strings
 hstore             | 1.7             |                   | data type for storing sets of (key, value) pairs
 hstore_plperl      | 1.0             |                   | transform between hstore and plperl
 hstore_plperlu     | 1.0             |                   | transform between hstore and plperlu
 insert_username    | 1.0             |                   | functions for tracking who changed a table
 intagg             | 1.1             |                   | integer aggregator and enumerator (obsolete)
 intarray           | 1.3             |                   | functions, operators, and index support for 1-D arrays of integers
 isn                | 1.2             |                   | data types for international product numbering standards
 jsonb_plperl       | 1.0             |                   | transform between jsonb and plperl
 jsonb_plperlu      | 1.0             |                   | transform between jsonb and plperlu
 lo                 | 1.1             |                   | Large Object maintenance
 ltree              | 1.2             |                   | data type for hierarchical tree-like structures
 moddatetime        | 1.0             |                   | functions for tracking last modification time
 pageinspect        | 1.8             |                   | inspect the contents of database pages at a low level
 pg_buffercache     | 1.3             |                   | examine the shared buffer cache
 pg_freespacemap    | 1.2             |                   | examine the free space map (FSM)
 pg_prewarm         | 1.2             |                   | prewarm relation data
 pg_stat_statements | 1.8             |                   | track planning and execution statistics of all SQL statements executed
 pg_trgm            | 1.5             |                   | text similarity measurement and index searching based on trigrams
 pg_visibility      | 1.2             |                   | examine the visibility map (VM) and page-level visibility info
 pgcrypto           | 1.3             |                   | cryptographic functions
 pgrowlocks         | 1.2             |                   | show row-level locking information
 pgstattuple        | 1.5             |                   | show tuple-level statistics
 refint             | 1.0             |                   | functions for implementing referential integrity (obsolete)
 seg                | 1.3             |                   | data type for representing line segments or floating-point intervals
 sslinfo            | 1.2             |                   | information about SSL certificates
 tablefunc          | 1.0             |                   | functions that manipulate whole tables, including crosstab
 tcn                | 1.0             |                   | Triggered change notifications
 tsm_system_rows    | 1.0             |                   | TABLESAMPLE method which accepts number of rows as a limit
 tsm_system_time    | 1.0             |                   | TABLESAMPLE method which accepts time in milliseconds as a limit
 unaccent           | 1.1             |                   | text search dictionary that removes accents
 uuid-ossp          | 1.1             |                   | generate universally unique identifiers (UUIDs)
 xml2               | 1.1             |                   | XPath querying and XSLT
(48 rows)


myposdb=#
スポンサーリンク