Search PostgreSQL documentation

gbuilderExtensionsExtensionsAdditional geometry builders gbuilder GeospatialGeospatial · Extensions gc_to_secFunctionsPG18gc_to_sec ( float8 ) → float8 Converts the great circle distance between two points on the surface of the Earth to the normal straight line (secant) distance between them.earthdistance — calculate great-circle distances › Cube-Based Earth Distances gcdFunctionsReferencegcd Mathematical Functions And Operators 13 Greatest common divisor (the largest positive number that divides both inputs with no remainder); returns 0 if both inputs are zero; available for…Functions · Mathematical Functions And Operators gcdExtensionsExtensionsC function that computes the greatest common divisor of an integer array. greatest-common-divisor integer-array math gcd Functions and aggregatesFunctions and aggregates · Extensions gdpr_anatomizerExtensionsExtensionsPrototype GDPR/anatomy anonymization extension implemented with PL/Python and PL/pgSQL helpers. postgresql_anatomy SecuritySecurity · Extensions geekspeakExtensionsExtensionsDatabase schema extension for the GeekSpeak podcast website. podcast schema website pg_geekspeak FeaturesFeatures · Extensions geekspeak_calendarExtensionsExtensionsCalendar and iCalendar integration for GeekSpeak podcast recording schedules and episodes. calendar ical podcast scheduling pg_geekspeak_calendar Time seriesTime series · Extensions gen_random_uuidFunctionsReferencegen_random_uuid Uuid Functions 13 This function returns a version 4 (random) UUID. This is the most commonly used type of UUID and is appropriate for most applications. gen_random_uuid () → …Functions · Uuid Functions gen_salt()Manual ChaptersPG18F.26.2.2. gen_salt() gen_salt(type text [, iter_count integer ]) returns text Generates a new random salt string for use in crypt(). The salt string also tells crypt() which algorithm to use…gen_salt() GeneralManual ChaptersPG1836.10.6.1. General The PostgreSQL server contains several well-demarcated APIs for server plugins, such as the function manager (fmgr, described in this chapter), SPI (Chapter 45), and vario…General General Coding GuidelinesManual ChaptersPG1850.1.2. General Coding Guidelines Developers should keep the following in mind when implementing token validation: Token Confidentiality Modules should not write tokens, or pieces of tokens,…General Coding Guidelines General FunctionsManual ChaptersPG18F.23.1. General Functions get_raw_page(relname text, fork text, blkno bigint) returns bytea get_raw_page reads the specified block of the named relation and returns a copy as a bytea value. …General Functions General FunctionsManual ChaptersPG18F.37.1. General Functions pg_get_wal_record_info(in_lsn pg_lsn) returns record # Gets WAL record information about a record that is located at or after the in_lsn argument. For example: post…General Functions General Hashing FunctionsManual ChaptersPG18F.26.1. General Hashing FunctionsGeneral Hashing Functions General PerformanceManual ChaptersPG18E.6.3.1.3. General Performance Add an asynchronous I/O subsystem (Andres Freund, Thomas Munro, Nazir Bilal Yavuz, Melanie Plageman) § § § § § § § § § § § This feature allows backends to queu…General Performance General PurposeManual ChaptersPG18General Purpose -B nbuffers Sets the number of shared buffers for use by the server processes. The default value of this parameter is chosen automatically by initdb. Specifying this option i…General Purpose generate_date_seriesExtensionsExtensionsgenerate_series()-style set-returning function for date ranges with integer day steps. date generate-series set-returning-function generate_date_series Functions and aggregatesFunctions and aggregates · Extensions generate_seriesFunctionsReferencegenerate_series Set Returning Functions 10 Generate a series of values, from start to stop with a step size of one generate_series ( start, stop ) → setof int, setof bigint, or setof numeric…Functions · Set Returning Functions generate_subscriptsFunctionsReferencegenerate_subscripts Set Returning Functions 10 Generate a series comprising the given array's subscripts. generate_subscripts ( array anyarray, dim int ) → setof int Generate a series compri…Functions · Set Returning Functions generate_up_down_seriesExtensionsExtensionsPostgreSQL Up Down Sequence c postgresql postgresql-extension series series-generator generate_up_down_series Functions and aggregatesFunctions and aggregates · Extensions Generated Column ReplicationManual ChaptersPG1829.6. Generated Column Replication Typically, a table at the subscriber will be defined the same as the publisher table, so if the publisher table has a GENERATED column then the subscriber …Generated Column Replication Generated ColumnsManual ChaptersPG185.4. Generated Columns A generated column is a special column that is always computed from other columns. Thus, it is for columns what a view is for tables. There are two kinds of generated …Generated Columns Generated ColumnsManual ChaptersPG18Generated Columns The options STORED and VIRTUAL are not standard but are also used by other SQL implementations. The SQL standard does not specify the storage of generated columns.Generated Columns Generating PGP Keys with GnuPGManual ChaptersPG18F.26.3.9. Generating PGP Keys with GnuPG To generate a new key: gpg --gen-key The preferred key type is “DSA and Elgamal”. For RSA encryption you must create either DSA or RSA sign-only key …Generating PGP Keys with GnuPG Generating Possible PlansManual ChaptersPG1851.5.1. Generating Possible Plans The planner/optimizer starts by generating plans for scanning each individual relation (table) used in the query. The possible plans are determined by the a…Generating Possible Plans Generating Possible Plans with GEQOManual ChaptersPG1861.3.1. Generating Possible Plans with GEQO The GEQO planning process uses the standard planner code to generate plans for scans of individual relations. Then join plans are developed using …Generating Possible Plans with GEQO Generic File Access FunctionsManual ChaptersPG189.28.9. Generic File Access Functions The functions shown in Table 9.108 provide native access to files on the machine hosting the server. Only files within the database cluster directory an…Generic File Access Functions Generic Message CallbackManual ChaptersPG1847.6.4.8. Generic Message Callback The optional message_cb callback is called whenever a logical decoding message has been decoded. typedef void (*LogicalDecodeMessageCB) (struct LogicalDeco…Generic Message Callback Generic WAL RecordsManual ChaptersPG1864.1. Generic WAL Records Although all built-in WAL-logged modules have their own types of WAL records, there is also a generic WAL record type, which describes changes to pages in a generic…Generic WAL Records generic_planExtensionsExtensionsGenerate a generic plan for a parameterized SQL statement. explain performance query-plan generic_plan MonitoringMonitoring · Extensions Genetic AlgorithmsManual ChaptersPG1861.2. Genetic Algorithms The genetic algorithm (GA) is a heuristic optimization method which operates through randomized search. The set of possible solutions for the optimization problem is…Genetic Algorithms Genetic Query Optimization (GEQO) in PostgreSQLManual ChaptersPG1861.3. Genetic Query Optimization (GEQO) in PostgreSQL The GEQO module approaches the query optimization problem as though it were the well-known traveling salesman problem (TSP). Possible qu…Genetic Query Optimization (GEQO) in PostgreSQL Genetic Query OptimizerManual ChaptersPG18Chapter 61. Genetic Query Optimizer Author Written by Martin Utesch (<utesch@aut.tu-freiberg.de>) for the Institute of Automatic Control at the University of Mining and Technology in Freiber…Genetic Query Optimizer Genetic Query OptimizerManual ChaptersPG1819.7.3. Genetic Query Optimizer The genetic query optimizer (GEQO) is an algorithm that does query planning using heuristic searching. This reduces planning time for complex queries (those j…Genetic Query Optimizer geohash_extraExtensionsExtensionsAdditional geohash functions geohash-extra GeospatialGeospatial · Extensions geohistorical_objectsExtensionsExtensionsGeohistorical objects support geohistorical_objects GeospatialGeospatial · Extensions geoipExtensionsExtensionsIP-based geolocation query pgdg-flaw geoip GeospatialGeospatial · Extensions geoip2lookupExtensionsExtensionsLook up IP-address info in MaxMind GeoIP2 MMDB files geolocation maxmind mmdb plperlu geoip2lookup GeospatialGeospatial · Extensions Geometric Functions and OperatorsManual ChaptersPG189.11. Geometric Functions and Operators The geometric types point, box, lseg, line, path, polygon, and circle have a large set of native support functions and operators, shown in Table 9.36,…Geometric Functions and Operators Geometric TypesManual ChaptersPG188.8. Geometric Types Geometric data types represent two-dimensional spatial objects. Table 8.20 shows the geometric types available in PostgreSQL. Table 8.20. Geometric Types Name Storage Si…Geometric Types