Search PostgreSQL documentation

LogicalSyncDataWait EventsReferenceLogicalSyncData IPC 10 Waiting for logical replication remote server to send data for initial table synchronization. 11 12 13 Waiting for a logical replication remote server to send data for…Wait Events · IPC LogicalSyncStateChangeWait EventsReferenceLogicalSyncStateChange IPC 10 Waiting for logical replication remote server to change state. 11 12 13 Waiting for a logical replication remote server to change state. 14 15 16 17 18 19 20 Br…Wait Events · IPC loginManual ChaptersPG1838.1.1. login The login event occurs when an authenticated user logs into the system. Any bug in a trigger procedure for this event may prevent successful login to the system. Such bugs may …login login_hookExtensionsExtensionslogin_hook - hook to execute login_hook.login() at login time login_hook SecuritySecurity · Extensions login_refuseExtensionsExtensionsAuthentication hook that temporarily refuses logins after repeated failures authentication login security login_refuse SecuritySecurity · Extensions loginfoExtensionsExtensionsFunctions and views for PostgreSQL to query the postgres log logging monitoring observability loginfo MonitoringMonitoring · Extensions loglog_counterExtensionsExtensionsAggregation functions and data type for distinct estimation based on LogLog. aggregate count distinct estimate loglog distinct_estimators Functions and aggregatesFunctions and aggregates · Extensions lolorExtensionsExtensionsLogical-replication-friendly replacement for PostgreSQL large objects fork pgedge lolor Replication and streamsReplication and streams · Extensions londisteExtensionsExtensionsLondiste replication support code logical-replication queue replication londiste Replication and streamsReplication and streams · Extensions longitudeFunctionsPG18longitude ( earth ) → float8 Returns the longitude in degrees of a point on the surface of the Earth.earthdistance — calculate great-circle distances › Cube-Based Earth Distances LOOPManual ChaptersPG1841.6.5.1. LOOP [ <<label>> ] LOOP statements END LOOP [ label ]; LOOP defines an unconditional loop that is repeated indefinitely until terminated by an EXIT or RETURN statement. The optiona…LOOP Looping through a Cursor's ResultManual ChaptersPG1841.7.4. Looping through a Cursor's Result There is a variant of the FOR statement that allows iterating through the rows returned by a cursor. The syntax is: [ <<label>> ] FOR recordvar IN b…Looping through a Cursor's Result Looping through ArraysManual ChaptersPG1841.6.7. Looping through Arrays The FOREACH loop is much like a FOR loop, but instead of iterating through the rows returned by an SQL query, it iterates through the elements of an array valu…Looping through Arrays Looping through Query ResultsManual ChaptersPG1841.6.6. Looping through Query Results Using a different type of FOR loop, you can iterate through the results of a query and manipulate that data accordingly. The syntax is: [ <<label>> ] FO…Looping through Query Results lostgisExtensionsExtensionsLostGIS spatial helper functions and types gis spatial spatiotemporal temporal tpv lostgis GeospatialGeospatial · Extensions lowerFunctionsReferencelower String Functions And Operators 10 Convert string to lower case lower ( string ) → text Convert string to lower case lower ( anyrange ) → range's element type lower bound of range 11 12…Functions · String Functions And Operators lower_incFunctionsReferencelower_inc Range/Multirange Functions And Operators 10 is the lower bound inclusive? lower_inc ( anyrange ) → boolean is the lower bound inclusive? 11 12 13 Is the range's lower bound inclusi…Functions · Range/Multirange Functions And Operators lower_infFunctionsReferencelower_inf Range/Multirange Functions And Operators 10 is the lower bound infinite? lower_inf ( anyrange ) → boolean is the lower bound infinite? 11 12 13 Is the range's lower bound infinite?…Functions · Range/Multirange Functions And Operators lower_quantileExtensionsExtensionsLower quantile aggregate function lower_quantile Functions and aggregatesFunctions and aggregates · Extensions lpadFunctionsReferencelpad String Functions And Operators 10 Fill up the string to length length by prepending the characters fill (a space by default). If the string is already longer than length then it is trun…Functions · String Functions And Operators lpathtreeExtensionsExtensionsHierarchical path types using slash-separated labels hierarchy path tree lpathtree Data typesData types · Extensions lsegData TypesPG18lseg line segment on a planeData Types lsegFunctionsReferencelseg Geometric Functions And Operators 10 box diagonal to line segment lseg ( box ) → lseg box diagonal to line segment lseg ( point, point ) → lseg points to line segment 11 12 13 Extracts …Functions · Geometric Functions And Operators lshvectorExtensionsExtensionsa feature vector type and a locality sensitive hashing index lshvector AI and vectorsAI and vectors · Extensions lsmExtensionsExtensionsRocksDB foreign data wrapper for PostgreSQL fdw key-value rocksdb lsm Foreign data wrappersForeign data wrappers · Extensions lsm3ExtensionsExtensionsLSM tree index access method based on PostgreSQL B-tree indexes btree index lsm lsm3 FeaturesFeatures · Extensions lsm_idxExtensionsExtensionsExperimental LSM-style index access method built on PostgreSQL B-tree internals access-method index lsm lsm_idx FeaturesFeatures · Extensions ltreeExtensionsPG18F.22. ltree — hierarchical tree-like data type This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for…ltree — hierarchical tree-like data type ltree — hierarchical tree-like data typeManual ChaptersPG18F.22. ltree — hierarchical tree-like data type This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for…ltree — hierarchical tree-like data type ltree2textFunctionsPG18ltree2text ( ltree ) → text Casts ltree to text.ltree — hierarchical tree-like data type › Operators and Functions ltree_plpython2uExtensionsExtensionsA fixed postgres xl so it can compile on newer versions of GCC and glibc ltree_plpython2u Procedural languagesProcedural languages · Extensions ltree_plpython3uExtensionsExtensionstransform between ltree and plpython3u plpython3u Procedural languagesProcedural languages · Extensions ltree_plpythonuExtensionsExtensionstransform between ltree and plpythonu ltree_plpythonu Procedural languagesProcedural languages · Extensions ltree_plrubyExtensionsExtensionsTransform between ltree and Ruby Arrays for PL/Ruby ltree ruby transform plruby Procedural languagesProcedural languages · Extensions ltrimFunctionsReferenceltrim String Functions And Operators 10 Remove the longest string containing only characters from characters (a space by default) from the start of string ltrim ( string text [, characters t…Functions · String Functions And Operators lua_fdwExtensionsExtensionsLua Foreign Data Wrapper fdw lua read-only lua_fdw Foreign data wrappersForeign data wrappers · Extensions ludia_funcsExtensionsExtensionsLudia full-text search helper functions fts japanese normalization snippet ludia_funcs Full-text searchFull-text search · Extensions lukasiewicz_logicExtensionsExtensionsProvides operators to evaluate fuzzy logic expressions according to Łukasiewicz logic. fuzzy gödel logic operators product łukasiewicz fuzzy_logic Functions and aggregatesFunctions and aggregates · Extensions LWLocksManual ChaptersPG1836.10.12. LWLocksLWLocks ly2pgExtensionsExtensionsImport LilyPond files into PostgreSQL dependency-closure ly2pg source-only sql pgwtc Replication and streamsReplication and streams · Extensions