AWS RDS PostgreSQL 查看支持的插件

SQL

rds.extensions是AWS封装的配置参数

postgres=> show rds.extensions;
-[ RECORD 1 ]--+--
rds.extensions | address_standardizer, address_standardizer_data_us, amcheck, autoinc, aws_commons, aws_lambda, aws_s3, bloom, bool_plperl, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, flow_control, fuzzystrmatch, h3, h3_postgis, hll, hstore, hstore_plperl, hypopg, insert_username, intagg, intarray, ip4r, isn, jsonb_plperl, lo, log_fdw, ltree, moddatetime, mysql_fdw, old_snapshot, oracle_fdw, orafce, pageinspect, pg_bigm, pg_buffercache, pg_cron, pg_freespacemap, pg_hint_plan, pg_partman, pg_prewarm, pg_proctab, pg_repack, pg_similarity, pg_stat_statements, pg_tle, pg_transport, pg_trgm, pg_visibility, pg_walinspect, pgactive, pgaudit, pgcrypto, pglogical, pgrouting, pgrowlocks, pgstattuple, pgtap, plcoffee, plls, plperl, plpgsql, plprofiler, plrust, pltcl, plv8, postgis, postgis_raster, postgis_tiger_geocoder, postgis_topology, postgres_fdw, prefix, rdkit, rds_tools, refint, seg, sslinfo, tablefunc, tcn, tds_fdw, test_parser, tsm_system_rows, tsm_system_time, unaccent, uuid-ossp, vector

或者

SELECT * FROM pg_available_extensions;

allowed_extensions

查看哪些扩展允许安装，*表示允许所有扩展安装。

postgres=> show rds.allowed_extensions ;
-[ RECORD 1 ]----------+--
rds.allowed_extensions | *