Postgres 扩展概述
扩展(Extensions)正如其名 - 它们通过非Postgres核心的功能来"扩展"数据库能力。 Supabase已预装了一些最实用的开源扩展。
启用与禁用扩展
- 进入控制面板的数据库页面
- 点击侧边栏中的扩展选项
- 启用或禁用扩展
大多数扩展安装在默认对public开放的extensions模式下。为避免命名空间污染，我们不建议在extensions模式下创建其他实体。
如需限制用户对扩展管理表的访问，建议为特定扩展创建独立模式。
某些扩展必须安装在特定模式下，例如postgis_tiger_geocoder扩展会创建名为tiger的模式。启用此类扩展前，请确保不存在同名冲突模式。
除了预配置的扩展，您还可以通过Supabase的SQL编辑器直接在数据库中安装自定义SQL扩展。包括plpgsql扩展在内的SQL代码都可以通过SQL编辑器添加。
升级扩展
当 Supabase 上有新版本的扩展可用时，您需要在基础设施设置中发起软件升级才能使用。也可以通过常规设置中重启服务器来触发软件升级。
完整扩展列表
Supabase 预装了超过 50 个扩展。您还可以通过我们的 SQL 编辑器直接在数据库中安装自己的 SQL 扩展。
Filter
address_standardizer
Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us
Address Standardizer US dataset example
amcheck
Functions for verifying relation integrity
autoinc
Functions for autoincrementing fields
bloom
Bloom access method - signature file based index
btree_gin
Support for indexing common datatypes in GIN
btree_gist
Support for indexing common datatypes in GiST
citext
Data type for case-insensitive character strings
cube
Data type for multidimensional cubes
dblink
Connect to other PostgreSQL databases from within a database
dict_int
Text search dictionary template for integers
dict_xsyn
Text search dictionary template for extended synonym processing
earthdistance
Calculate great-circle distances on the surface of the Earth
fuzzystrmatch
Determine similarities and distance between strings
hstore
Data type for storing sets of (key, value) pairs
hypopg
Hypothetical indexes for PostgreSQL
http
HTTP client for PostgreSQL, allows web page retrieval inside the database.
insert_username
Functions for tracking who changed a table
old_snapshot
Utilities in support of old_snapshot_threshold
index_advisor
Optimize query performance with automatic index recommendation
intarray
Functions, operators, and index support for 1-D arrays of integers
isn
Data types for international product numbering standards
lo
Large Object maintenance
ltree
Data type for hierarchical tree-like structures
moddatetime
Functions for tracking last modification time
pg_cron
Job scheduler for PostgreSQL
pg_freespacemap
Examine the free space map (FSM)
pg_graphql
Pg_graphql: GraphQL support
pg_hashids
Pg_hashids
pg_jsonschema
Pg_jsonschema
pg_net
Async HTTP
pg_prewarm
Prewarm relation data
pg_stat_statements
Track execution statistics of all SQL statements executed
pg_surgery
Extension to perform surgery on a damaged relation
pg_trgm
Text similarity measurement and index searching based on trigrams
pgaudit
Provides auditing functionality
pg_walinspect
Functions to inspect contents of PostgreSQL Write-Ahead Log
pgcrypto
Cryptographic functions
pgjwt
JSON Web Token API for Postgresql
pgroonga
Super fast and all languages supported full text search index based on Groonga
pgroonga_database
PGroonga database management module
pgrouting
PgRouting Extension
pgrowlocks
Show row-level locking information
pgsodium
Postgres extension for libsodium functions
pgstattuple
Show tuple-level statistics
pgtap
Unit testing for PostgreSQL
plcoffee
PL/CoffeeScript (v8) trusted procedural language
pljava
PL/Java procedural language (https://tada.github.io/pljava/)
plls
PL/LiveScript (v8) trusted procedural language
plpgsql
PL/pgSQL procedural language
plpgsql_check
Extended check for plpgsql functions
plv8
PL/JavaScript (v8) trusted procedural language
postgis
PostGIS geometry and geography spatial types and functions
postgres_fdw
Foreign-data wrapper for remote PostgreSQL servers
refint
Functions for implementing referential integrity (obsolete)
rum
GIN-like index for text search
seg
Data type for representing line segments or floating-point intervals
sslinfo
Information about SSL certificates
tablefunc
Functions that manipulate whole tables, including crosstab
tcn
Triggered change notifications
timescaledb
Enables scalable inserts and complex queries for time-series data
tsm_system_rows
TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time
TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent
Text search dictionary that removes accents
uuid-ossp
Generate universally unique identifiers (UUIDs)
vector
Vector data type with similarity search
pg_repack
Optimize physical storage and remove bloat from tables and indexes
wrappers
Foreign data wrappers developed by Supabase