Search PostgreSQL documentation

pg_comment_statsExtensionsExtensionsMonitoring · ExtensionsAggregate resource usage by key-value annotations in SQL comments statistics query comments pg_comment_stats Monitoring pg_concurrency_controlExtensionsExtensionsAdministration · ExtensionsConcurrency control plug-in for Alibaba Cloud ApsaraDB RDS PostgreSQL pg_concurrency_control Administration pg_condaExtensionsExtensionsData types · ExtensionsPostgreSQL extension adding conda ecosystem version types, aggregates, and functions. conda data-type pgrx pg_conda Data types pg_configManual ChaptersPG18retrieve information about the installed version of PostgreSQL Synopsis pg_config [option...] pg_configManual ChaptersPG18The view pg_config describes the compile-time configuration parameters of the currently installed version of PostgreSQL. It is intended, for example, to be used by software packages that wan… pg_config --bindirCommand-line ToolsPG18pg_config › Optionsbindir Print the location of user executables. Use this, for example, to find the psql program. This is normally also the location where the pg_config program resides. pg_config --ccCommand-line ToolsPG18pg_config › Optionscc Print the value of the CC variable that was used for building PostgreSQL. This shows the C compiler used. pg_config --cflagsCommand-line ToolsPG18pg_config › Optionscflags Print the value of the CFLAGS variable that was used for building PostgreSQL. This shows C compiler switches. pg_config --cflags_slCommand-line ToolsPG18pg_config › Optionscflags_sl Print the value of the CFLAGS_SL variable that was used for building PostgreSQL. This shows extra C compiler switches used for building shared libraries. pg_config --configureCommand-line ToolsPG18pg_config › Optionsconfigure Print the options that were given to the configure script when PostgreSQL was configured for building. This can be used to reproduce the identical configuration, or to find out wit… pg_config --cppflagsCommand-line ToolsPG18pg_config › Optionscppflags Print the value of the CPPFLAGS variable that was used for building PostgreSQL. This shows C compiler switches needed at preprocessing time (typically, -I switches). pg_config --docdirCommand-line ToolsPG18pg_config › Optionsdocdir Print the location of documentation files. pg_config --helpCommand-line ToolsPG18pg_config › Options?--help Show help about pg_config command line arguments, and exit. pg_config --htmldirCommand-line ToolsPG18pg_config › Optionshtmldir Print the location of HTML documentation files. pg_config --includedirCommand-line ToolsPG18pg_config › Optionsincludedir Print the location of C header files of the client interfaces. pg_config --includedir-serverCommand-line ToolsPG18pg_config › Optionsincludedir-server Print the location of C header files for server programming. pg_config --ldflagsCommand-line ToolsPG18pg_config › Optionsldflags Print the value of the LDFLAGS variable that was used for building PostgreSQL. This shows linker switches. pg_config --ldflags_exCommand-line ToolsPG18pg_config › Optionsldflags_ex Print the value of the LDFLAGS_EX variable that was used for building PostgreSQL. This shows linker switches used for building executables only. pg_config --ldflags_slCommand-line ToolsPG18pg_config › Optionsldflags_sl Print the value of the LDFLAGS_SL variable that was used for building PostgreSQL. This shows linker switches used for building shared libraries only. pg_config --libdirCommand-line ToolsPG18pg_config › Optionslibdir Print the location of object code libraries. pg_config --libsCommand-line ToolsPG18pg_config › Optionslibs Print the value of the LIBS variable that was used for building PostgreSQL. This normally contains -l switches for external libraries linked into PostgreSQL. pg_config --localedirCommand-line ToolsPG18pg_config › Optionslocaledir Print the location of locale support files. (This will be an empty string if locale support was not configured when PostgreSQL was built.) pg_config --mandirCommand-line ToolsPG18pg_config › Optionsmandir Print the location of manual pages. pg_config --pgxsCommand-line ToolsPG18pg_config › Optionspgxs Print the location of extension makefiles. pg_config --pkgincludedirCommand-line ToolsPG18pg_config › Optionspkgincludedir Print the location of other C header files. pg_config --pkglibdirCommand-line ToolsPG18pg_config › Optionspkglibdir Print the location of dynamically loadable modules, or where the server would search for them. (Other architecture-dependent data files might also be installed in this directory.) pg_config --sharedirCommand-line ToolsPG18pg_config › Optionssharedir Print the location of architecture-independent support files. pg_config --sysconfdirCommand-line ToolsPG18pg_config › Optionssysconfdir Print the location of system-wide configuration files. pg_config --versionCommand-line ToolsPG18pg_config › Optionsversion Print the version of PostgreSQL. pg_conn2ExtensionsExtensionsForeign data wrappers · ExtensionsManage separate PostgreSQL database connections from SQL code pg_conn2 Foreign data wrappers pg_connlimitExtensionsExtensionsAdministration · ExtensionsLimits per-role connection counts from filesystem configuration without catalog access. pg_connlimit Administration pg_constraintManual ChaptersPG18The catalog pg_constraint stores check, not-null, primary key, unique, foreign key, and exclusion constraints on tables. (Column constraints are not treated specially. Every column constrain… pg_consulExtensionsExtensionsUtilities · ExtensionsC++ PostgreSQL extension exposing SQL functions for Consul status, catalog, and key-value APIs. consul key-value service-discovery pg_consul Utilities pg_contextdumpExtensionsExtensionsMonitoring · ExtensionsReports allocated-memory statistics for PostgreSQL memory contexts. pg_memorydump Monitoring pg_control_priorityExtensionsExtensionsAdministration · ExtensionsControls scheduling priorities (nice values) of PostgreSQL server processes. process-control resource-management pg_control_priority Administration pg_controldataManual ChaptersPG18display control information of a PostgreSQL database cluster Synopsis pg_controldata [option] [[ -D | --pgdata ]datadir] pg_conversionManual ChaptersPG18The catalog pg_conversion describes encoding conversion functions. See CREATE CONVERSION for more information. Table 52.14. pg_conversion Columns Column Type Description oid oid Row identifi… pg_cooldownExtensionsExtensionsAdministration · Extensionsremove buffered pages for specific relations pg_cooldown Administration pg_coredumpExtensionsExtensionsAdministration · ExtensionsEasier core dump collection for PostgreSQL pg_coredump Administration pg_crashExtensionsExtensionsAdministration · ExtensionsSend random signals to random processes pg_crash Administration