产品动态
CREATE EXTENSION [ IF NOT EXISTS ] extension_name[ WITH ][ SCHEMA schema_name ][ VERSION version ][ FROM old_version ]
\\dxList of installed extensionsName | Version | Schema | Description---------------+---------+------------+---------------------------------------------------------------------amcheck | 1.2 | public | functions for verifying relation integritybloom | 1.0 | public | bloom access method - signature file based indexhstore | 1.6 | public | data type for storing sets of (key, value) pairshstore_plperl | 1.0 | public | transform between hstore and plperljsonb_plperl | 1.0 | public | transform between jsonb and plperlplperl | 1.0 | pg_catalog | PL/Perl procedural languageplpgsql | 1.0 | pg_catalog | PL/pgSQL procedural languagepostgis | 3.0.2 | public | PostGIS geometry, geography, and raster spatial types and functions(8 rows)
select * from pg_available_extensions where installed_version is not null; 语句查看已安装的插件列表。name | default_version | installed_version | comment---------------+-----------------+-------------------+---------------------------------------------------------------------plperl | 1.0 | 1.0 | PL/Perl procedural languageamcheck | 1.2 | 1.2 | functions for verifying relation integrityhstore_plperl | 1.0 | 1.0 | transform between hstore and plperlplpgsql | 1.0 | 1.0 | PL/pgSQL procedural languagejsonb_plperl | 1.0 | 1.0 | transform between jsonb and plperlhstore | 1.6 | 1.6 | data type for storing sets of (key, value) pairsbloom | 1.0 | 1.0 | bloom access method - signature file based indexpostgis | 3.0.2 | 3.0.2 | PostGIS geometry, geography, and raster spatial types and functions(8 rows)
文档反馈