설문조사
PostgreSQL/PPAS 관련 듣고 싶은 교육은


총 게시물 72건, 최근 0 건
   

가용 확장모듈및 설치된 확장모듈 살펴보기 (extension)

글쓴이 : PostgresDBA 날짜 : 2014-10-31 (금) 01:05 조회 : 4874
postgres@[local]:5432:postgres] 
SQL> select * from pg_available_extensions;
        name        | default_version | installed_version |                               comment                                
--------------------+-----------------+-------------------+----------------------------------------------------------------------
 sslinfo            | 1.0             | <NULL>            | information about SSL certificates
 lo                 | 1.0             | <NULL>            | Large Object maintenance
 insert_username    | 1.0             | <NULL>            | functions for tracking who changed a table
 dblink             | 1.1             | <NULL>            | connect to other PostgreSQL databases from within a database
 earthdistance      | 1.0             | <NULL>            | calculate great-circle distances on the surface of the Earth
 pldbgapi           | 1.0             | <NULL>            | server-side support for debugging PL/pgSQL functions
 btree_gist         | 1.0             | <NULL>            | support for indexing common datatypes in GiST
 uuid-ossp          | 1.0             | <NULL>            | generate universally unique identifiers (UUIDs)
 xml2               | 1.0             | <NULL>            | XPath querying and XSLT
 isn                | 1.0             | <NULL>            | data types for international product numbering standards
 plpython3u         | 1.0             | <NULL>            | PL/Python3U untrusted procedural language
 pgrowlocks         | 1.1             | <NULL>            | show row-level locking information
 file_fdw           | 1.0             | <NULL>            | foreign-data wrapper for flat file access
 dict_int           | 1.0             | <NULL>            | text search dictionary template for integers
 pg_freespacemap    | 1.0             | <NULL>            | examine the free space map (FSM)
 moddatetime        | 1.0             | <NULL>            | functions for tracking last modification time
 refint             | 1.0             | <NULL>            | functions for implementing referential integrity (obsolete)
 autoinc            | 1.0             | <NULL>            | functions for autoincrementing fields
 pg_stat_statements | 1.1             | 1.1               | track execution statistics of all SQL statements executed
 pgstattuple        | 1.1             | <NULL>            | show tuple-level statistics
 chkpass            | 1.0             | <NULL>            | data type for auto-encrypted passwords
 plperl             | 1.0             | <NULL>            | PL/Perl procedural language
 fuzzystrmatch      | 1.0             | <NULL>            | determine similarities and distance between strings
 pltclu             | 1.0             | <NULL>            | PL/TclU untrusted procedural language
 test_parser        | 1.0             | <NULL>            | example of a custom parser for full-text search
 plpgsql            | 1.0             | 1.0               | PL/pgSQL procedural language
 tablefunc          | 1.0             | <NULL>            | functions that manipulate whole tables, including crosstab
 intagg             | 1.0             | <NULL>            | integer aggregator and enumerator (obsolete)
 timetravel         | 1.0             | <NULL>            | functions for implementing time travel
 pg_buffercache     | 1.0             | <NULL>            | examine the shared buffer cache
 unaccent           | 1.0             | <NULL>            | text search dictionary that removes accents
 pageinspect        | 1.1             | <NULL>            | inspect the contents of database pages at a low level
 cube               | 1.0             | <NULL>            | data type for multidimensional cubes
 tcn                | 1.0             | <NULL>            | Triggered change notifications
 btree_gin          | 1.0             | <NULL>            | support for indexing common datatypes in GIN
 pltcl              | 1.0             | <NULL>            | PL/Tcl procedural language
 dict_xsyn          | 1.0             | <NULL>            | text search dictionary template for extended synonym processing
 pgcrypto           | 1.0             | <NULL>            | cryptographic functions
 pg_trgm            | 1.1             | <NULL>            | text similarity measurement and index searching based on trigrams
 ltree              | 1.0             | <NULL>            | data type for hierarchical tree-like structures
 adminpack          | 1.0             | 1.0               | administrative functions for PostgreSQL
 seg                | 1.0             | <NULL>            | data type for representing line segments or floating-point intervals
 tsearch2           | 1.0             | <NULL>            | compatibility package for pre-8.3 text search functions
 hstore             | 1.2             | <NULL>            | data type for storing sets of (key, value) pairs
 plperlu            | 1.0             | <NULL>            | PL/PerlU untrusted procedural language
 postgres_fdw       | 1.0             | <NULL>            | foreign-data wrapper for remote PostgreSQL servers
 citext             | 1.0             | <NULL>            | data type for case-insensitive character strings
 intarray           | 1.0             | <NULL>            | functions, operators, and index support for 1-D arrays of integers
(48 rows)

postgres@[local]:5432:postgres] 
SQL> select * from pg_extension;
      extname       | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition 
--------------------+----------+--------------+----------------+------------+-----------+--------------
 plpgsql            |       10 |           11 | f              | 1.0        | <NULL>    | <NULL>
 adminpack          |       10 |           11 | f              | 1.0        | <NULL>    | <NULL>
 pg_stat_statements |       10 |         2200 | t              | 1.1        | <NULL>    | <NULL>
(3 rows)

postgres@[local]:5432:postgres] 
SQL> \dx
                                     List of installed extensions
        Name        | Version |   Schema   |                        Description                        
--------------------+---------+------------+-----------------------------------------------------------
 adminpack          | 1.0     | pg_catalog | administrative functions for PostgreSQL
 pg_stat_statements | 1.1     | public     | track execution statistics of all SQL statements executed
 plpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural language
(3 rows)

postgres@[local]:5432:postgres] 
SQL> 

   

postgresdba.com