Search PostgreSQL documentation

earthFunctionsPG18earth () → float8 Returns the assumed radius of the Earth.earthdistance — calculate great-circle distances › Cube-Based Earth Distances earth_boxFunctionsPG18earth_box ( earth, float8 ) → cube Returns a box suitable for an indexed search using the cube @> operator for points within a given great circle distance of a location. Some points in this …earthdistance — calculate great-circle distances › Cube-Based Earth Distances earth_distanceFunctionsPG18earth_distance ( earth, earth ) → float8 Returns the great circle distance between two points on the surface of the Earth.earthdistance — calculate great-circle distances › Cube-Based Earth Distances earthdistanceExtensionsPG18F.14. earthdistance — calculate great-circle distances The earthdistance module provides two different approaches to calculating great circle distances on the surface of the Earth. The one d…earthdistance — calculate great-circle distances earthdistance — calculate great-circle distancesManual ChaptersPG18F.14. earthdistance — calculate great-circle distances The earthdistance module provides two different approaches to calculating great circle distances on the surface of the Earth. The one d…earthdistance — calculate great-circle distances ebs_fdwExtensionsExtensionsRust/pgrx foreign data wrapper for listing AWS EBS volumes through PostgreSQL. aws ebs fdw pgrx olddog Foreign data wrappersForeign data wrappers · Extensions ecazExtensionsExtensionsRust PostgreSQL extension for high-performance vector storage with broad quantization and index support. agent-ix ai embeddings machine-learning pgrx postgresql postgresql-extension quantiza…AI and vectors · Extensions ecpgCommand-line ToolsPG18ecpg ecpg — embedded SQL C preprocessor Synopsis ecpg [option...] file...ecpg ecpgManual ChaptersPG18ecpg ecpg — embedded SQL C preprocessor Synopsis ecpg [option...] file...ecpg ecpg --helpCommand-line ToolsPG18-?--help Show help about ecpg command line arguments, and exit.ecpg › Options ecpg --versionCommand-line ToolsPG18--version Print the ecpg version and exit.ecpg › Options ecpg -cCommand-line ToolsPG18-c Automatically generate certain C code from SQL code. Currently, this works for EXEC SQL TYPE.ecpg › Options ecpg -C modeCommand-line ToolsPG18-C mode Set a compatibility mode. mode can be INFORMIX, INFORMIX_SE, or ORACLE.ecpg › Options ecpg -D symbol[=value]Command-line ToolsPG18-D symbol[=value] Define a preprocessor symbol, equivalently to the EXEC SQL DEFINE directive. If no value is specified, the symbol is defined with the value 1.ecpg › Options ecpg -hCommand-line ToolsPG18-h Process header files. When this option is specified, the output file extension becomes .h not .c, and the default input file extension is .pgh not .pgc. Also, the -c option is forced on.ecpg › Options ecpg -iCommand-line ToolsPG18-i Parse system include files as well.ecpg › Options ecpg -I directoryCommand-line ToolsPG18-I directory Specify an additional include path, used to find files included via EXEC SQL INCLUDE. Defaults are . (current directory), /usr/local/include, the PostgreSQL include directory wh…ecpg › Options ecpg -o filenameCommand-line ToolsPG18-o filename Specifies that ecpg should write all its output to the given filename. Write -o - to send all output to standard output.ecpg › Options ecpg -r optionCommand-line ToolsPG18-r option Selects run-time behavior. Option can be one of the following: no_indicator Do not use indicators but instead use special values to represent null values. Historically there have b…ecpg › Options ecpg -tCommand-line ToolsPG18-t Turn on autocommit of transactions. In this mode, each SQL command is automatically committed unless it is inside an explicit transaction block. In the default mode, commands are committe…ecpg › Options ecpg -vCommand-line ToolsPG18-v Print additional information including the version and the "include" path.ecpg › Options ecpg no_indicatorCommand-line ToolsPG18no_indicator Do not use indicators but instead use special values to represent null values. Historically there have been databases using this approach.ecpg › Options ecpg prepareCommand-line ToolsPG18prepare Prepare all statements before using them. Libecpg will keep a cache of prepared statements and reuse a statement if it gets executed again. If the cache runs full, libecpg will free …ecpg › Options ecpg questionmarksCommand-line ToolsPG18questionmarks Allow question mark as placeholder for compatibility reasons. This used to be the default long ago.ecpg › Options ECPG — Embedded SQL in CManual ChaptersPG18Chapter 34. ECPG — Embedded SQL in C This chapter describes the embedded SQL package for PostgreSQL. It was written by Linus Tolke (<linus@epact.se>) and Michael Meskes (<meskes@postgresql.o…ECPG — Embedded SQL in C ed25519ExtensionsExtensionsPostgreSQL extension for a modern and secure digital signature algorithm based on performance-optimized elliptic curves cardano cryptography ed25519 postgresql-extension ed25519 SecuritySecurity · Extensions edb_block_commandsExtensionsExtensionsRestricts EDB Advanced Server superusers from utility, DML, and SELECT commands using whitelist GUCs. command-blocking edb-advanced-server security session-preload superuser edb_block_comman…Security · Extensions edb_cloneschemaExtensionsExtensionsLocal and cross-database schema cloning for EPAS. schema clone migration parallel edb_cloneschema AdministrationAdministration · Extensions edb_foreignkeyconstraintmanagerExtensionsExtensionsManage trigger-based foreign-key behavior for partitioned tables on EDB Postgres Advanced Server edb foreign-key partitioning edb_foreignkeyconstraintmanager AdministrationAdministration · Extensions edb_job_schedulerExtensionsExtensionsEPAS background-worker runtime for scheduled database jobs. scheduler jobs background-worker oracle edb_job_scheduler Time seriesTime series · Extensions edb_otelExtensionsExtensionsOpenTelemetry metrics and trace export for PostgreSQL and EDB extensions. opentelemetry metrics tracing observability edb_otel MonitoringMonitoring · Extensions edb_pg_tunerExtensionsExtensionsResource and workload analysis with PostgreSQL tuning recommendations. tuning configuration recommendation autotune edb_pg_tuner AdministrationAdministration · Extensions edb_stat_monitorExtensionsExtensionsBucketed query execution statistics for PostgreSQL and EDB Postgres. query statistics monitoring buckets edb_stat_monitor MonitoringMonitoring · Extensions edb_wait_statesExtensionsExtensionsPersistent sampling of backend wait events and related query context. wait-events sampling performance monitoring edb_wait_states MonitoringMonitoring · Extensions Editing the PO FilesManual ChaptersPG1856.1.4. Editing the PO Files The PO files can be edited with a regular text editor. There are also several specialized editors for PO files which can help the process with translation-specif…Editing the PO Files ednbExtensionsExtensionsPostgres extension to support EDN as a custom datatype ednb Data typesData types · Extensions edtf_postgresExtensionsExtensionsEDTF validation, normalization, date bounds, and temporal relations. edtf iso-8601 temporal date edtf Time seriesTime series · Extensions effective_cache_sizeConfigurationReferenceeffective_cache_size Query Tuning 10 Sets the planner's assumption about the effective size of the disk cache that is available to a single query. This is factored into estimates of the cost…Configuration · Query Tuning effective_io_concurrencyConfigurationReferenceeffective_io_concurrency Resource Usage 10 Sets the number of concurrent disk I/O operations that PostgreSQL expects can be executed simultaneously. Raising this value will increase the numb…Configuration · Resource Usage effective_wal_levelConfigurationReferenceeffective_wal_level Preset Options 19 Reports the actual WAL logging level currently in effect in the system. This parameter shares the same set of values as wal_level, but reflects the oper…Configuration · Preset Options