Page tree

VNG Cloud Help Center

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

PostgreSQL nổi tiếng với tính linh hoạt. Bạn hoàn toàn có thể mở rộng các core-function Postgresql bằng các Extension.

vDB PostgreSQL hỗ trợ bạn sử dụng các Postgresql Extension theo hai cách:

  • Bật sẵn trong database template1
  • Bạn tự bật khi có nhu cầu.


Danh sách các extension được bật sẵn:

Mặc định các database được tạo mới sẽ được bật sẵn các Extension trong template1.

Sau khi tạo database, bạn có thể dùng lệnh \dx hoặc select * from pg_extension; để xem danh sách các extension đã được bật trên database.


NameVersionDescription
btree_gin1.2support for indexing common datatypes in GIN
btree_gist1.5support for indexing common datatypes in GiST
chkpass1data type for auto-encrypted passwords
citext1.4data type for case-insensitive character strings
cube1.2data type for multidimensional cubes
dict_int1text search dictionary template for integers
dict_xsyn1text search dictionary template for extended synonym processing
hstore1.4data type for storing sets of (key, value) pairs
isn1.1data types for international product numbering standards
lo1.1Large Object maintenance
ltree1.1data type for hierarchical tree-like structures
plpgsql1PL/pgSQL procedural language
postgis2.5.4PostGIS geometry, geography, and raster spatial types and functions


Danh sách các extension bạn có thể tự bật:

Ngoài ra, bạn có thể tự bật bằng cách chạy lệnh: Create Extension <tên_extension>;

NameVersionDescription
address_standardizer2.5.4Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us2.5.4Address Standardizer US dataset example
amcheck1functions for verifying relation integrity
autoinc1functions for autoincrementing fields
earthdistance1.1calculate great-circle distances on the surface of the Earth
fuzzystrmatch1.1determine similarities and distance between strings
insert_username1functions for tracking who changed a table
intagg1.1integer aggregator and enumerator (obsolete)
intarray1.2functions, operators, and index support for 1-D arrays of integers
moddatetime1functions for tracking last modification time
pageinspect1.6inspect the contents of database pages at a low level
pg_buffercache1.3examine the shared buffer cache
pg_freespacemap1.2examine the free space map (FSM)
pg_prewarm1.1prewarm relation data
pg_stat_statements1.6track execution statistics of all SQL statements executed
pg_trgm1.3text similarity measurement and index searching based on trigrams
pg_visibility1.2examine the visibility map (VM) and page-level visibility info
pgcrypto1.3cryptographic functions
pgrouting3.0.0pgRouting Extension
pgrowlocks1.2show row-level locking information
pgstattuple1.5show tuple-level statistics
postgis_sfcgal2.5.4PostGIS SFCGAL functions
postgis_tiger_geocoder2.5.4PostGIS tiger geocoder and reverse geocoder
postgis_topology2.5.4PostGIS topology spatial types and functions
refint1functions for implementing referential integrity (obsolete)
sslinfo1.2information about SSL certificates
tablefunc1functions that manipulate whole tables, including crosstab
tcn1Triggered change notifications
timetravel1functions for implementing time travel
tsm_system_rows1TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time1TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent1.1text search dictionary that removes accents
uuid-ossp1.1generate universally unique identifiers (UUIDs)
ngoài ra bạn có thể dùng lệnh select * from pg_available_extensions; để kiểm tra danh sách cập nhật mới nhất các extension khả dụng trên vDB PostgreSQL của bạn.

Nếu bạn cần extension nào chưa được hỗ trợ, vui lòng liên hệ với VNG Cloud Support.


  • No labels