pgPedia

一本（仍在进行中）关于PostgreSQL相关事物的百科全书。还有一些技巧。

A

abbrev()
abs()
acldefault()
aclexplode()
acos()
acosd()
acosh()
建议性锁定
allow_alter_system
allow_in_place_tablespaces
allow_system_table_mods
ALTER AGGREGATE
ALTER COLLATION
ALTER CONVERSION
ALTER DATABASE
ALTER DEFAULT PRIVILEGES
ALTER DOMAIN
ALTER EVENT TRIGGER
ALTER EXTENSION
ALTER FOREIGN DATA WRAPPER
ALTER FOREIGN TABLE
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER LARGE OBJECT
ALTER MATERIALIZED VIEW
ALTER OPERATOR
ALTER OPERATOR CLASS
ALTER OPERATOR FAMILY
ALTER POLICY
ALTER PROCEDURE
ALTER PUBLICATION
ALTER ROLE
ALTER ROUTINE
ALTER RULE
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER STATISTICS
ALTER SUBSCRIPTION
ALTER SYSTEM
ALTER TABLE
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TEXT SEARCH PARSER
ALTER TEXT SEARCH TEMPLATE
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER USER MAPPING
ALTER VIEW
amcheck
ANALYZE
application_name
archive_cleanup_command
archive_command
archive_library
archive_mode
archive_timeout
数组
ARRAY[]
array_agg()
array_append()
array_cat()
array_dims()
array_fill()
array_length()
array_lower()
array_ndims()
array_nulls
array_position()
array_positions()
array_prepend()
array_remove()
array_replace()
array_reverse()
array_sample()
array_shuffle()
array_sort()
array_to_json()
array_to_string()
array_to_tsvector()
array_upper()
ascii()
AsciiDoc
asin()
asind()
asinh()
atan()
atan2()
atan2d()
atand()
atanh()
auth_delay
authentication_timeout
auto_explain
autovacuum
autovacuum_analyze_scale_factor
autovacuum_analyze_threshold
autovacuum_max_workers
autovacuum_naptime
autovacuum_vacuum_cost_delay
autovacuum_vacuum_cost_limit
autovacuum_vacuum_insert_scale_factor
autovacuum_vacuum_insert_threshold
autovacuum_vacuum_max_threshold
autovacuum_vacuum_scale_factor
autovacuum_vacuum_threshold
autovacuum_worker_slots
autovacuum_work_mem

B

后台工作进程
后台写入器
backslash_quote
backtrace_functions
backtrace_on_internal_error
备份块
备份历史文件
backup_label
Barman
basic_archive
BEGIN
bit_and()
bit_count()
bit_length()
bit_or()
bit_xor()
块范围索引 (BRIN)
block_size
bloom
bonjour
bonjour_name
bool_and()
bool_or()
bool_plperl
bool_plperlu
brin (测试模块)
broadcast()
btree_gin
btree_gist
btrim()
bytea
bytea_output

C

CALL
cardinality()
级联复制
casefold()
目录版本号
cbrt()
ceil()
ceiling()
cfbot
character_length()
char_length()
check_function_bodies
check_password_hook
检查点 (Checkpoint)
CHECKPOINT
checkpoint_completion_target
检查点进程 (Checkpointer)
checkpoint_flush_after
checkpoint_timeout
checkpoint_warning
check_postgres
chr()
citext
ClientAuthentication_hook
client_connection_check_interval
client_encoding
client_min_messages
clock_timestamp()
CLOSE
CLUSTER
clusterdb
cluster_name
col_description()
命令标签
COMMENT ON
COMMIT
commit_delay
CommitFest
提交日志 (CLOG)
提交已准备事务
commit_siblings
commit_ts
通用表表达式（CTE）
compute_query_id
concat()
concat_ws()
config_file
连接服务文件
conninfo
Contrib模块
convert()
convert_from()
convert_to()
COPY
核心工具
cos()
cosd()
cosh()
cot()
cotd()
crc32()
crc32c()
CREATE ACCESS METHOD
CREATE AGGREGATE
CREATE CAST
CREATE COLLATION
CREATE CONVERSION
CREATE DATABASE
createdb
CREATE DOMAIN
CREATE EVENT TRIGGER
CREATE EXTENSION
CREATE FOREIGN DATA WRAPPER
CREATE FOREIGN TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE LANGUAGE
CREATE MATERIALIZED VIEW
CREATE OPERATOR
CREATE OPERATOR CLASS
CREATE OPERATOR FAMILY
CREATE POLICY
CREATE PROCEDURE
CREATE PUBLICATION
CREATE ROLE
createrole_self_grant
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE STATISTICS
CREATE SUBSCRIPTION
CREATE TABLE
CREATE TABLE AS
CREATE TABLESPACE
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TEXT SEARCH PARSER
CREATE TEXT SEARCH TEMPLATE
CREATE TRANSFORM
CREATE TRIGGER
CREATE TYPE
create_upper_paths_hook
createuser
CREATE USER
CREATE USER MAPPING
CREATE VIEW
CSV
CSV日志格式
cube
current_catalog
current_database()
current_date
current_query()
current_role
current_schema
current_schema()
current_schemas()
current_setting()
current_time
current_timestamp
current_user
currval()
cursor_to_xml()
cursor_to_xmlschema()
cursor_tuple_fraction
CVS

D

数据库系统标识符
database_to_xml()
database_to_xml_and_xmlschema()
database_to_xmlschema()
data_checksums
data_directory
data_directory_mode
数据页校验和
data_sync_retry
date_add()
date_bin()
date_part()
DateStyle
date_subtract()
date_trunc()
DBD::Pg
dblink
deadlock_timeout
DEALLOCATE
debug_assertions
debug_deadlocks
debug_discard_caches
debug_logical_replication_streaming
debug_parallel_query
debug_pretty_print
debug_print_parse
debug_print_plan
debug_print_rewritten
声明式分区
DECLARE
decode()
default_statistics_target
default_table_access_method
default_tablespace
default_text_search_config
default_toast_compression
default_transaction_read_only
degrees()
DELETE
dict_int
dict_xsyn
直接 I/O
放弃
div()
DO
DocBook XML
Dollar quoting
域名
DROP ACCESS METHOD
DROP AGGREGATE
DROP CAST
DROP COLLATION
DROP CONVERSION
DROP DATABASE
dropdb
DROP DOMAIN
DROP EVENT TRIGGER
DROP EXTENSION
DROP FOREIGN DATA WRAPPER
DROP FOREIGN TABLE
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MATERIALIZED VIEW
DROP OPERATOR
DROP OPERATOR CLASS
DROP OPERATOR FAMILY
DROP OWNED
DROP POLICY
DROP PROCEDURE
DROP PUBLICATION
DROP ROLE
DROP ROUTINE
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP STATISTICS
DROP SUBSCRIPTION
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TEXT SEARCH PARSER
DROP TEXT SEARCH TEMPLATE
DROP TRANSFORM
DROP TRIGGER
DROP TYPE
dropuser
DROP USER
DROP USER MAPPING
DROP VIEW
DUAL table
dummy_index_am
dummy_seclabel
dynamic_library_path
dynamic_shared_memory_type

E

earthdistance
ECPG
effective_cache_size
effective_io_concurrency
emit_log_hook
enable_async_append
enable_distinct_reordering
enable_incremental_sort
enable_indexonlyscan
enable_indexscan
enable_memoize
enable_parallel_insert
enable_partition_pruning
enable_partitionwise_aggregate
enable_partitionwise_join
enable_presorted_aggregate
enable_self_join_elimination
enable_self_join_removal
enable_seqscan
encode()
END
ENUM
EOL (End of Life)
erf()
erfc()
escape_string_warning
event_source
事件触发器
event_triggers
EXECUTE
ExecutorCheckPerms_hook
ExecutorEnd_hook
ExecutorFinish_hook
ExecutorRun_hook
ExecutorStart_hook
exit_on_error
exp()
EXPLAIN
explain_get_index_name_hook
ExplainOneQuery_hook
扩展
extension_control_path
external_pid_file
extract()
extra_float_digits

F

factorial()
fallback_application_name
family()
FETCH
file_copy_method
file_fdw
filenode
firebird_fdw
floor()
fmgr_hook
force_parallel_mode
外部数据包装器 (FDW)
外键
外部表
分支
format()
format_type()
前端/后端协议
fsync
full_page_writes
全文搜索
func_beg
func_end
func_setup
fuzzystrmatch

G

gamma()
gcd()
生成的列
generate_series()
generate_subscripts()
gen_random_uuid()
get_attavgwidth_hook
get_bit()
get_byte()
get_current_ts_config()
get_index_stats_hook
get_relation_info_hook
get_relation_stats_hook
gin_clean_pending_list()
gin_fuzzy_search_limit
GIN (广义倒排索引)
gin_pending_list_limit
GIT
GRANT
greatest()
gss_accept_delegation
GUC - Grand Unified Configuration (统一配置)
pg_get_loaded_modules()

H

has_any_column_privilege()
has_column_privilege()
has_database_privilege()
has_foreign_data_wrapper_privilege()
has_function_privilege()
hash_mem_multiplier
has_language_privilege()
has_largeobject_privilege()
has_parameter_privilege()
has_schema_privilege()
has_sequence_privilege()
has_server_privilege()
has_table_privilege()
has_tablespace_privilege()
has_type_privilege()
hba_file
钩子
host()
hostmask()
hot_standby
hstore
hstore_plperl
hstore_plpython
huge_pages
huge_page_size
huge_pages_status
HypoPG

I

debug_io_direct
icu_unicode_version()
icu_validation_level
ident_file
IDENTIFY_SYSTEM
idle_in_transaction_session_timeout
idle_replication_slot_timeout
idle_session_timeout
ignore_checksum_failure
ignore_invalid_pages
ignore_system_indexes
IMPORT FOREIGN SCHEMA
include
include_dir
include_if_exists
inet_client_addr()
inet_client_port()
inet_merge()
inet_same_family()
inet_server_addr()
inet_server_port()
信息模式
in_hot_standby
initcap()
initdb
初始化 fork
INSERT
intagg
intarray
integer_datetimes
IntervalStyle
io_combine_limit
io_max_combine_limit
io_method
io_workers
isempty()
isfinite()
isn
隔离测试器
is_superuser

J

JDBC
jit
jit_debugging_support
jit_dump_bitcode
jit_profiling_support
jit_provider
join_collapse_limit
join_search_hook
json_agg()
json_array_elements()
json_array_elements_text()
json_array_length()
jsonb_array_elements()
jsonb_array_elements_text()
jsonb_array_length()
jsonb_build_array()
jsonb_build_object()
jsonb_each()
jsonb_each_text()
jsonb_insert()
jsonb_object()
jsonb_object_keys()
jsonb_populate_record()
jsonb_populate_record_valid()
jsonb_pretty()
jsonb_set()
jsonb_set_lax()
jsonb_strip_nulls()
jsonb_to_tsvector()
jsonb_typeof()
json_build_array()
json_build_object()
json_each()
json_each_text()
json_extract_path()
json_extract_path_text()
json_object()
json_object_keys()
json_populate_record()
json_populate_recordset()
json_strip_nulls()
json_to_tsvector()
json_typeof()
justify_days()
justify_hours()
justify_interval()

K

kNN (k 最近邻)
krb_caseins_users
krb_server_keyfile

L

大对象 (Large object)
lastval()
lcm()
lc_messages
lc_monetary
lc_numeric
lc_time
ldap_password_hook
least()
left()
length()
lgamma()
libpgcommon
libpq
LISTEN
listen_addresses
ln()
lo
LOAD
local_preload_libraries
localtime
localtimestamp
LOCK
lock_timeout
lo_compat_privileges
lo_from_bytea()
log()
log10()
log_autovacuum_min_duration
log_btree_build_stats
log_checkpoints
log_connections
log_destination
log_directory
log_disconnections
log_duration
log_error_verbosity
lo_get()
log_executor_stats
log_file_mode
log_filename
logging_collector
logical_decoding_work_mem
逻辑复制 (Logical replication)
login_hook
log_line_prefix
log_lock_failures
log_lock_waits
log_min_duration_sample
log_min_duration_statement
log_min_messages
log_parameter_max_length
log_parameter_max_length_on_error
log_parser_stats
log_planner_stats
log_recovery_conflict_waits
log_replication_commands
log_rotation_age
log_rotation_size
log_startup_progress_interval
log_statement
log_statement_sample_rate
log_statement_stats
log_temp_files
log_timezone
log_transaction_sample_rate
log_truncate_on_rotation
lo_put()
lower()
lower_inc()
lower_inf()
lower(range)
lpad()
LSN (日志序列号 - Log Sequence Number)
ltree
ltrim()

M

maintenance_io_concurrency
maintenance_work_mem
makeaclitem()
make_date()
make_interval()
make_time()
make_timestamp()
make_timestamptz()
masklen()
max_active_replication_origins
max_connections
max_files_per_process
max_fsm_pages
max_function_args
max_identifier_length
max_index_keys
max_locks_per_transaction
max_logical_replication_workers
max_notify_queue_pages
max_parallel_apply_workers_per_subscription
max_parallel_maintenance_workers
max_parallel_workers
max_parallel_workers_per_gather
max_prepared_transactions
max_replication_slots
max_slot_wal_keep_size
max_stack_depth
max_standby_archive_delay
max_standby_streaming_delay
max_sync_workers_per_subscription
max_wal_senders
max_wal_size
max_worker_processes
md5()
md5_password_warnings
MERGE
min_dynamic_shared_memory
min_parallel_index_scan_size
min_parallel_relation_size
min_parallel_table_scan_size
min_scale()
min_wal_size
MobilityDB
mod()
MOVE
multirange
multirange()
多事务 ID
mysql_fdw

N

NAMEDATALEN
needs_fmgr_hook
netmask()
network()
nextval()
normalize()
NOTIFY
now()
numeric
numeric_fac()
numeric_power()
numnode()
num_nonnulls()
num_nulls()
num_os_semaphores

O

oauth_validator_libraries
obj_description()
object_access_hook
对象标识符类型
octet_length()
OID
oid2name
old_snapshot
old_snapshot_threshold
openssl_tls_init_hook
operator_precedence_warning
ora2pg
oracle_fdw
orafce
or_to_any_transform_limit
overlay()
psqlODBC

P

pageinspect
parallel_leader_participation
parallel_setup_cost
parallel_workers
parse_ident()
分区表
passwordcheck
password_encryption
Patroni
pause_at_recovery_target
pgAdmin
pgAdmin III
pg_advisory_lock()
pg_advisory_lock_shared()
pg_advisory_unlock()
pg_advisory_unlock_all()
pg_advisory_unlock_shared()
pg_advisory_xact_lock()
pg_advisory_xact_lock_shared()
pgAgent
pg_aggregate
pgagroal
pg_aios
pg_alterckey
pg_am
pg_amcheck
pg_amop
pg_amproc
pg_archivecleanup
pg_attrdef
pg_attribute
pgAudit
pg_authid
pg_auth_members
pg_available_extensions
pg_available_extension_versions
pg_available_wal_summaries()
pg_backend_memory_contexts
pg_backend_pid()
pg_backup_start()
pg_backup_start_time()
pg_backup_stop()
pg_basebackup
pg_basetype()
pgbench
pg_bigm
pg_blocking_pids()
PgBouncer
pgbouncer_fdw
pg_buffercache
pg_bulkload
pg_cancel_backend()
pg_cast
pg_char_to_encoding()
pg_checksums
pg_class
pg_clear_attribute_stats()
pg_clear_relation_stats()
pg_client_encoding()
pg_collation
pg_collation_actual_version()
pg_collation_is_visible()
pg_column_compression()
pg_column_size()
pg_column_toast_chunk_id()
pg_combinebackup
pg_config
pg_config (视图)
pg_conf_load_time()
pg_constraint
pg_control
pg_control_checkpoint()
pg_controldata
pg_control_init()
pg_control_recovery()
pg_control_system()
pg_conversion
pg_copy_logical_replication_slot()
pg_copy_physical_replication_slot()
pg_create_logical_replication_slot()
pg_create_physical_replication_slot()
pg_create_restore_point()
pg_createsubscriber
pg_cron
pgcrypto
pg_ctl
pg_current_logfile()
pg_current_snapshot()
pg_current_wal_flush_lsn()
pg_current_wal_lsn()
pg_current_xact_id()
pg_current_xact_id_if_assigned()
pg_cursors
pg_database
pg_database_collation_actual_version()
pg_database_size()
pg_db_role_setting
pg_default_acl
pg_depend
pg_describe_object()
pg_description
pg_dirtyread
pg_drop_replication_slot()
pg_dsm_registry_allocations
pg_dump
pg_dumpall
pg_encoding_to_char()
pg_enum
pgenv
pg_event_trigger
pg_export_snapshot()
pg_extension
pg_extension_config_dump()
pg_extension_update_paths()
pg_filedump
pg_filenode.map
pg_filenode_relation()
pg_file_settings
pg_foreign_data_wrapper
pg_foreign_server
pg_foreign_table
pg_format (pgFormatter)
pg_freespacemap
pg_function_is_visible()
pg_get_acl()
pg_get_catalog_foreign_keys()
pg_get_constraintdef()
pg_get_expr()
pg_get_function_arguments()
pg_get_functiondef()
pg_get_function_identity_arguments()
pg_get_function_result()
pg_get_indexdef()
pg_get_keywords()
pg_get_object_address()
pg_get_partkeydef()
pg_get_process_memory_contexts()
pg_get_ruledef()
pg_get_sequence_data()
pg_get_serial_sequence()
pg_get_triggerdef()
pg_get_userbyid()
pg_get_viewdef()
pg_get_wal_replay_pause_state()
pg_get_wal_summarizer_state()
pg_group
pg_has_role()
pg_hba.conf
pg_hba_file_rules
pg_hint_plan
pg_ident_file_mappings
pg_identify_object()
pg_identify_object_as_address()
pg_import_system_collations()
pg_index
pg_indexes
pg_indexes_size()
pg_inherits
pg_init_privs
pg_input_error_info()
pg_input_is_valid()
pg_internal.init
pg_is_in_backup()
pg_is_in_recovery()
pg_is_other_temp_schema()
pg_isready
pg_is_wal_replay_paused()
pg_jit_available()
pg_language
pg_largeobject
pg_largeobject_metadata
pg_last_committed_xact()
pg_last_wal_receive_lsn()
pg_last_wal_replay_lsn()
pg_last_xact_replay_timestamp()
pg_listening_channels()
pg_locks
pg_log_backend_memory_contexts()
pglogical
pg_logical_emit_message()
pg_logicalinspect
pg_logical_slot_get_binary_changes()
pg_logical_slot_get_changes()
pg_logical_slot_peek_binary_changes()
pg_logical_slot_peek_changes()
pg_log_standby_snapshot()
pg_ls_archive_statusdir()
pg_ls_dir()
pg_ls_logdir()
pg_ls_logicalmapdir()
pg_ls_logicalsnapdir()
pg_lsn
pg_ls_replslotdir()
pg_ls_summariesdir()
pg_ls_tmpdir()
pg_ls_waldir()
pg_matviews
pg_my_temp_schema()
pg_namespace
pg_node_tree
pg_notification_queue_usage()
pg_notify()
pg_numa_available()
pg_opclass
pg_opclass_is_visible()
pg_operator
pg_operator_is_visible()
pg_opfamily
pg_opfamily_is_visible()
pg_options_to_table()
pg_parameter_acl
pg_partition_ancestors()
pg_partitioned_table
pg_partition_root()
pg_partition_tree()
pg_partman
pg_pltemplate
pg_policies
pg_policy
Pgpool-II
pg_postmaster_start_time()
pg_prepared_statements
pg_prepared_xacts
pg_prewarm
pg_proc
pg_promote()
pg_publication
pg_publication_namespace
pg_publication_rel
pg_publication_sequences
pg_publication_tables
pg_range
pg_read_binary_file()
pg_read_file()
pg_receivewal
pg_recvlogical
pg_regress
pg_relation_check_pages()
pg_relation_filenode()
pg_relation_filepath()
pg_relation_is_publishable()
pg_relation_size()
pg_reload_conf()
pg_repack
pg_replay
pg_replication_origin
pg_replication_origin_advance()
pg_replication_origin_create()
pg_replication_origin_drop()
pg_replication_origin_oid()
pg_replication_origin_progress()
pg_replication_origin_session_is_setup()
pg_replication_origin_session_progress()
pg_replication_origin_session_reset()
pg_replication_origin_session_setup()
pg_replication_origin_status
pg_replication_slot_advance()
pg_replication_slots
pg_resetwal
pg_restore
pg_restore_attribute_stats()
pg_restore_relation_stats()
pg_rewind
pg_rewrite
pg_rman
pg_roles
pg_rotate_logfile()
pgrowlocks
pg_rules
pg_seclabel
pg_seclabels
pg_sequence
pg_sequences
pg_service.conf
pg_set_attribute_stats()
pg_set_relation_stats()
pg_settings
pg_settings_get_flags()
pg_shadow
pg_shdepend
pg_shdescription
pg_shmem_allocations
pg_shmem_allocations_numa
pg_shseclabel
pg_size_bytes()
pg_size_pretty()
pg_sleep()
pg_sleep_for()
pg_sleep_until()
pg_snakeoil
pg_snapshot_xip()
pg_snapshot_xmax()
pg_snapshot_xmin()
pg_split_walfile_name()
pgsql-hackers
pg_standby
pg_start_backup()
pg_stat_activity
pg_stat_all_indexes
pg_stat_all_tables
pg_stat_archiver
pg_stat_bgwriter
pg_stat_checkpointer
pg_stat_database
pg_stat_database_conflicts
pg_statement_rollback
pg_stat_file()
pg_stat_get_activity()
pg_stat_get_backend_activity()
pg_stat_get_backend_activity_start()
pg_stat_get_backend_client_addr()
pg_stat_get_backend_client_port()
pg_stat_get_backend_dbid()
pg_stat_get_backend_idset()
pg_stat_get_backend_io()
pg_stat_get_backend_pid()
pg_stat_get_backend_start()
pg_stat_get_backend_subxact()
pg_stat_get_backend_userid()
pg_stat_get_backend_wait_event()
pg_stat_get_backend_wait_event_type()
pg_stat_get_backend_wal()
pg_stat_get_backend_xact_start()
pg_stat_get_xact_blocks_fetched()
pg_stat_get_xact_blocks_hit()
pg_stat_gssapi
pg_stat_io
pg_statio_all_indexes
pg_statio_all_sequences
pg_statio_all_tables
pg_statio_sys_indexes
pg_statio_sys_sequences
pg_statio_sys_tables
pg_statio_user_indexes
pg_statio_user_sequences
pg_statio_user_tables
pg_statistic
pg_statistic_ext
pg_statistic_ext_data
pg_stat_prefetch_recovery
pg_stat_progress_analyze
pg_stat_progress_basebackup
pg_stat_progress_cluster
pg_stat_progress_copy
pg_stat_progress_create_index
pg_stat_progress_vacuum
pg_stat_recovery_prefetch
pg_stat_replication
pg_stat_replication_slots
pg_stat_reset()
pg_stat_reset_backend_stats()
pg_stat_reset_replication_slot()
pg_stat_reset_shared()
pg_stat_reset_single_function_counters()
pg_stat_reset_single_table_counters()
pg_stat_reset_slru()
pg_stats
pg_stats_ext
pg_stats_ext_exprs
pg_stat_slru
pg_stat_ssl
pg_stat_statements
pg_stat_subscription
pg_stat_subscription_stats
pg_stat_sys_indexes
pg_stat_sys_tables
pgstattuple
pg_stat_user_functions
pg_stat_user_indexes
pg_stat_user_tables
pg_stat_wal
pg_stat_wal_receiver
pg_stat_xact_all_tables
pg_stat_xact_sys_tables
pg_stat_xact_user_functions
pg_stat_xact_user_tables
pg_stop_backup()
pg_subscription
pg_subscription_rel
pg_surgery
pg_switch_wal()
pg_sync_replication_slots()
pg_table_is_visible()
pg_tables
pg_table_size()
pg_tablespace
pg_tablespace_databases()
pg_tablespace_location()
pg_tablespace_size()
pg_terminate_backend()
pg_test_fsync
pg_test_timing
pg_timetable
pg_timezone_abbrevs
pg_timezone_names
pgtop
pg_top
pg_total_relation_size()
pg_transform
pg_trgm
pg_trigger
pg_trigger_depth()
pg_try_advisory_lock()
pg_try_advisory_lock_shared()
pg_try_advisory_xact_lock()
pg_try_advisory_xact_lock_shared()
pg_ts_config
pg_ts_config_map
pg_ts_dict
pg_ts_parser
pg_ts_template
pgtt - PostgreSQL 全局临时表
pg_type
pg_type_is_visible()
pg_typeof()
pg_upgrade
pg_user
pg_user_mapping
pg_user_mappings
pg_variable
pg_verifybackup
pg_verify_checksums
PG_VERSION (文件)
pg_views
pg_visibility
pg_visible_in_snapshot()
pg_wait_events
pg_wait_for_backend_termination()
pg_wal
pg_waldump
pg_walfile_name()
pg_walfile_name_offset()
pg_walinspect
pg_wal_lsn_diff()
pg_wal_replay_pause()
pg_wal_replay_resume()
pg_wal_replay_wait()
pg_wal_replay_wait_status()
pg_walsummary
pg_wal_summary_contents()
pgx
pg_xact
pg_xact_commit_timestamp()
pg_xact_commit_timestamp_origin()
pg_xact_status()
pg_xlog
PGXN
PGXS
PHP
phpPgAdmin
phraseto_tsquery()
pi()
plainto_tsquery()
plan_cache_mode
Planet PostgreSQL
planner_hook
PL/Java
PL/Perl
PL/Python
PL/R
PL/Sample
PLV8
port
position()
post_auth_delay
PostGIS
postgres 数据库
postgres_fdw
postgresql.auto.conf
postgresql.conf
PostgreSQL 许可证
PostgreSQL 周刊新闻
PostgreSQL wiki
Postgres Weekly
Postgres-XL
Postico
postmaster.opts
postmaster.pid
post_parse_analyze_hook
power()
pre_auth_delay
预定义角色
PREPARE
PREPARE TRANSACTION
primary_conninfo
primary_slot_name
权限
过程语言
ProcessUtility_hook
进度报告
promote_trigger_file
psql
.psqlrc / psqlrc
psycopg2
发布

Q

query_id_squash_values
query_to_xml()
query_to_xml_and_xmlschema()
query_to_xmlschema()
querytree()
quote_all_identifiers
quote_ident()
quote_literal()
quote_nullable()

R

radians()
random()
random_normal()
random_page_cost
range_merge()
REASSIGN OWNED
recovery_end_command
recovery_init_sync_method
recovery_min_apply_delay
recovery_prefetch
recovery_prefetch_fpw
recovery_target
recovery_target_action
recovery_target_name
递归查询
recursive_worktable_factor
REDO 记录
REDO WAL 文件
REFRESH MATERIALIZED VIEW
regexp_count()
regexp_instr()
regexp_like()
regexp_match()
regexp_matches()
regexp_replace()
regexp_split_to_array()
regexp_split_to_table()
regexp_substr()
REINDEX
reindexdb
RELEASE SAVEPOINT
remove_temp_files_after_crash
repeat()
replace()
repmgr
reserved_connections
RESET
重置角色
restart_after_crash
重启点
restore_command
restrict_nonsystem_relation_kind
reverse()
REVOKE
right()
ROLLBACK
ROLLBACK PREPARED
回滚到保存点
round()
row_security_policy_hook_permissive
row_security_policy_hook_restrictive
row_to_json()
rpad()
rtrim()

S

SAVEPOINT
scale()
schema_to_xml()
schema_to_xml_and_xmlschema()
schema_to_xmlschema()
scram_iterations
SECURITY LABEL
seg
segment_size
SELECT INTO
send_abort_for_crash
send_abort_for_kill
sepgsql
序列关系
server_encoding
服务器编程接口 (SPI)
服务器工具
server_version
server_version_num
session_preload_libraries
session_replication_role
session_user
SET
set_bit()
set_byte()
set_config()
SET CONSTRAINTS
set_join_pathlist_hook
set_masklen()
set_rel_pathlist_hook
SET ROLE
setseed()
SET SESSION AUTHORIZATION
SET TRANSACTION
setval()
setweight()
sha224()
sha256()
sha384()
sha512()
shared_memory_size
shared_memory_size_in_huge_pages
shared_memory_type
shared_preload_libraries
shmem_request_hook
shmem_startup_hook
shobj_description()
SHOW
sign()
sin()
sind()
sinh()
斜杠命令
smgr
sort_mem
SP-GiST
spi
split_part()
sqlite_fdw
SQL/MED
sqrt()
ssl
ssl_ca_file
ssl_cert_file
ssl_ciphers
ssl_crl_dir
ssl_crl_file
ssl_dh_params_file
ssl_ecdh_curve
ssl_groups
sslinfo
ssl_key_file
ssl_library
ssl_max_protocol_version
ssl_min_protocol_version
ssl_passphrase_command
ssl_passphrase_command_supports_reload
ssl_prefer_server_ciphers
ssl_tls13_ciphers
standard_conforming_strings
standby_mode
standby.signal
start-scripts
starts_with()
START TRANSACTION
statement_timeout
statement_timestamp()
统计收集器
stats_fetch_consistency
stats_temp_directory
stmt_beg
stmt_end
存储参数
string_agg()
string_to_array()
string_to_table()
strpos()
substr()
substring()
summarize_wal
superuser_reserved_connections
suppress_redundant_updates_trigger
synchronized_standby_slots
synchronize_seqscans
synchronous_commit
synchronous_standby_names
sync_replication_slots
syslog_facility
syslog_ident
syslog_sequence_numbers
syslog_split_messages
系统目录

T

TABLE
tablefunc
表空间
表空间目录
tablespace_map
table_to_xml()
table_to_xml_and_xmlschema()
table_to_xmlschema()
tan()
tand()
tanh()
TAP 测试
target_session_attrs
tcn
temp_buffers
temp_file_limit
temp_tablespaces
test_bloomfilter
test_ddl_deparse
test_decoding
test_extensions
test_ginpostinglist
test_integerset
test_misc
测试模块
test_parser
test_pg_dump
test_predtest
test_rbtree
test_rls_hooks
test_shm_mq
text()
timeofday()
TimescaleDB
TimeZone
timezone_abbreviations
to_ascii()
to_bin()
to_char()
to_date()
to_hex()
to_json()
to_jsonb()
to_number()
to_oct()
to_regclass()
to_regcollation()
to_regdatabase()
to_regnamespace()
to_regoper()
to_regoperator()
to_regproc()
to_regprocedure()
to_regrole()
to_regtype()
to_regtypemod()
Torn page
to_timestamp()
to_tsquery()
to_tsvector()
trace_connection_negotiation
trace_lock_oidmin
trace_locks
trace_lock_table
trace_lwlocks
trace_notify
trace_recovery_messages
trace_sort
trace_userlocks
track_activities
track_activity_query_size
track_commit_timestamp
track_cost_delay_timing
track_counts
track_functions
track_io_timing
track_wal_io_timing
transaction_isolation
transaction_read_only
transaction_timeout
transaction_timestamp()
Transform
transform_null_equals
translate()
trim()
trim_array()
trim_scale()
trunc()
TRUNCATE
受信任的扩展
ts_debug()
ts_delete()
tsearch2
ts_filter()
ts_headline()
ts_lexize()
tsm_system_rows
tsm_system_time
ts_parse()
tsquery_phrase()
ts_rank()
ts_rank_cd()
ts_stat()
ts_token_type()
tsvector_to_array()
txid_current()
txid_current_if_assigned()
txid_current_snapshot()
txid_snapshot_xip()
txid_snapshot_xmax()
txid_snapshot_xmin()
txid_status()
txid_visible_in_snapshot()

U

unaccent
unicode_assigned()
unicode_version()
unistr()
unix_socket_directories
unix_socket_group
unix_socket_permissions
UNLISTEN
未记录表
unnest()
unsafe_tests
UPDATE
update_process_title
upper()
upper_inc()
upper_inf()
upper(range)
user
UUID
uuid_extract_timestamp()
uuid_extract_version()
uuid-ossp
uuidv4()
uuidv7()

V

VACUUM
vacuum_buffer_usage_limit
vacuum_cleanup_index_scale_factor
vacuum_cost_delay
vacuum_cost_limit
vacuum_cost_page_dirty
vacuum_cost_page_hit
vacuum_cost_page_miss
vacuumdb
vacuum_defer_cleanup_age
vacuumlo
vacuum_max_eager_freeze_failure_rate
vacuum_truncate
VALUES
version()

W

wal2json
wal2mongo
wal_block_size
wal_compression
wal_consistency_checking
wal_debug
wal_decode_buffer_size
wal_init_zero
wal_keep_segments
wal_keep_size
wal_level
wal_log_hints
wal_receiver_create_temp_slot
wal_receiver_status_interval
wal_recycle
wal_retrieve_retry_interval
wal_segment_size
walsender 状态
wal_sender_timeout
wal_skip_threshold
wal_summary_keep_time
wal_sync_method
wal_writer_delay
wal_writer_flush_after
websearch_to_tsquery()
width_bucket()
窗口函数
worker_spi
work_mem
写前日志 (WAL)

X

XLOG_PAGE_MAGIC
XLogRecPtr
xml2
xmlagg()
xmlbinary
xmlcomment()
xmlconcat()
xmlelement()
xmlforest()
xml_is_well_formed()
xml_is_well_formed_content()
xml_is_well_formed_document()
xmloption
xmlpi()
xmlroot()
xmlserialize()
xmltext()
xpath()
xpath_exists()

Y

YugabyteDB

Z

zero_damaged_pages
zheap

版本图表

实用概述

有用链接

咖啡

pgPedia