Search PostgreSQL documentation

Functions and OperatorsManual ChaptersPG18F.35.2. Functions and Operators The functions provided by the pg_trgm module are shown in Table F.26, the operators in Table F.27. Table F.26. pg_trgm Functions Function Description similari…Functions and Operators Functions Associated with Pipeline ModeManual ChaptersPG1832.5.2. Functions Associated with Pipeline Mode PQpipelineStatus # Returns the current pipeline mode status of the libpq connection. PGpipelineStatus PQpipelineStatus(const PGconn *conn); PQ…Functions Associated with Pipeline Mode Functions Associated with the COPY CommandManual ChaptersPG1832.10. Functions Associated with the COPY Command The COPY command in PostgreSQL has options to read from or write to the network connection used by libpq. The functions described in this se…Functions Associated with the COPY Command Functions for Producing OutputManual ChaptersPG1847.6.5. Functions for Producing Output To actually produce output, output plugins can write data to the StringInfo output buffer in ctx->out when inside the begin_cb, commit_cb, or change_cb…Functions for Producing Output Functions for Receiving COPY DataManual ChaptersPG1832.10.2. Functions for Receiving COPY Data These functions are used to receive data during COPY TO STDOUT. They will fail if called when the connection is not in COPY_OUT state. PQgetCopyDat…Functions for Receiving COPY Data Functions for Sending Cancel RequestsManual ChaptersPG1832.7.1. Functions for Sending Cancel Requests PQcancelCreate Prepares a connection over which a cancel request can be sent. PGcancelConn *PQcancelCreate(PGconn *conn); PQcancelCreate creates…Functions for Sending Cancel Requests Functions for Sending COPY DataManual ChaptersPG1832.10.1. Functions for Sending COPY Data These functions are used to send data during COPY FROM STDIN. They will fail if called when the connection is not in COPY_IN state. PQputCopyData # S…Functions for Sending COPY Data Functions ProvidedManual ChaptersPG18F.42.1. Functions Provided ssl_is_used() returns boolean Returns true if current connection to server uses SSL, and false otherwise. ssl_version() returns text Returns the name of the protoc…Functions Provided Functions ProvidedManual ChaptersPG18F.43.1. Functions Provided Table F.33 summarizes the functions provided by the tablefunc module. Table F.33. tablefunc Functions Function Description normal_rand ( numvals integer, mean floa…Functions Provided Further InformationManual ChaptersPG184. Further Information Besides the documentation, that is, this book, there are other resources about PostgreSQL: Wiki The PostgreSQL wiki contains the project's FAQ (Frequently Asked Questi…Further Information Further ReadingManual ChaptersPG1861.4. Further Reading The following resources contain additional information about genetic algorithms: The Hitch-Hiker's Guide to Evolutionary Computation, (FAQ for news://comp.ai.genetic) E…Further Reading Further ReadingManual ChaptersPG1823.3.5. Further Reading These are good sources to start learning about various kinds of encoding systems. CJKV Information Processing: Chinese, Japanese, Korean & Vietnamese Computing Contai…Further Reading Future Implementation Tasks for PostgreSQL GEQOManual ChaptersPG1861.3.2. Future Implementation Tasks for PostgreSQL GEQO Work is still needed to improve the genetic algorithm parameter settings. In file src/backend/optimizer/geqo/geqo_main.c, routines gim…Future Implementation Tasks for PostgreSQL GEQO fuzzeringExtensionsExtensionssearch string content fuzzering Full-text searchFull-text search · Extensions fuzzysearchExtensionsExtensionsPostgreSQL extension for strings fuzzy matching postgresql-extension fuzzysearch Full-text searchFull-text search · Extensions fuzzystrmatchExtensionsPG18F.16. fuzzystrmatch — determine string similarities and distance The fuzzystrmatch module provides several functions to determine similarities and distance between strings. This module is co…fuzzystrmatch — determine string similarities and distance fuzzystrmatch — determine string similarities and distanceManual ChaptersPG18F.16. fuzzystrmatch — determine string similarities and distance The fuzzystrmatch module provides several functions to determine similarities and distance between strings. Caution At presen…fuzzystrmatch — determine string similarities and distance fuzzywuzzyExtensionsExtensionsfuzzywuzzy ratio for postgres pg-fuzzywuzzy Full-text searchFull-text search · Extensions fzyExtensionsExtensionsFZY algorithm for PostgreSQL fuzzy-matching search pg_fzy Full-text searchFull-text search · Extensions g_cubeExtensionsExtensionsGPU version of contrib/cube g_cube Data typesData types · Extensions gammaFunctionsReferencegamma Mathematical Functions And Operators 18 Gamma function gamma ( double precision ) → double precision Gamma function 19 20Functions · Mathematical Functions And Operators ganos_address_standardizerExtensionsExtensionsA placename standardization extension based on the PAGC standard. ganos_address_standardizer GeospatialGeospatial · Extensions ganos_address_standardizer_data_usExtensionsExtensionsA placename standardization (United States) data extension based on the PAGC standard. address-standardization ganos pagc us-data ganos_address_standardizer_data_us GeospatialGeospatial · Extensions ganos_geometryExtensionsExtensionsProvides computing and analysis features for spatial geometry types. alibaba-cloud ganosbase geometry spatial ganos_geometry GeospatialGeospatial · Extensions ganos_geometry_pyramidExtensionsExtensionsBuilds sparse vector tile pyramids for fast rendering of large 2D geometry datasets. alibaba-cloud ganosbase geometry vector-tiles ganos_geometry_pyramid GeospatialGeospatial · Extensions ganos_geometry_sfcgalExtensionsExtensionsProvides extension features for the spatial geometry SFCGAL plugin. ganos_geometry_sfcgal GeospatialGeospatial · Extensions ganos_geometry_topologyExtensionsExtensionsGanos geometry topology spatial types and functions extension for PostgreSQL. ganos gis topology ganos_geometry_topology GeospatialGeospatial · Extensions ganos_geomgridExtensionsExtensionsProvides grid partitioning, encoding, indexing, and analysis capabilities for H3, GeoSOT, and other grid systems. ganos_geomgrid GeospatialGeospatial · Extensions ganos_networkingExtensionsExtensionsRoad and traffic network analysis with cost-based shortest, fastest, and optimal path algorithms. alibaba-cloud ganosbase routing spatial-network ganos_networking GeospatialGeospatial · Extensions ganos_pointcloudExtensionsExtensionsProvides storage, computing, and analysis features for point clouds. ganos_pointcloud GeospatialGeospatial · Extensions ganos_pointcloud_geometryExtensionsExtensionsIntegrates GanosBase PointCloud types with geometry for spatial analysis. alibaba-cloud ganosbase geometry point-cloud ganos_pointcloud_geometry GeospatialGeospatial · Extensions ganos_rasterExtensionsExtensionsProvides storage, computing, and analysis features for spatial raster data. ganos_raster GeospatialGeospatial · Extensions ganos_spatialrefExtensionsExtensionsProvides computing and analysis features for spatial references. ganos_spatialref GeospatialGeospatial · Extensions ganos_tiger_geocoderExtensionsExtensionsGanos tiger geocoder and reverse geocoder with support for USCB TIGER data. ganos_tiger_geocoder GeospatialGeospatial · Extensions ganos_trajectoryExtensionsExtensionsModels, queries, and analyzes moving-object trajectories across space and time. alibaba-cloud ganosbase moving-objects spatiotemporal trajectory ganos_trajectory GeospatialGeospatial · Extensions garbagemapExtensionsExtensionsA simple, pluggable background worker for PostgreSQL, walking over WAL background-worker postgresql postgresql-extension garbagemap AdministrationAdministration · Extensions garyaustin-test_tleExtensionsExtensionstest custom-properties. database.dev tle garyaustin-test_tle FeaturesFeatures · Extensions Gathering Document StatisticsManual ChaptersPG1812.4.4. Gathering Document Statistics The function ts_stat is useful for checking your configuration and for finding stop-word candidates. ts_stat(sqlquery text, [ weights text, ] OUT word t…Gathering Document Statistics gb18030_2022ExtensionsExtensionsSupport GB18030-2022 and UTF-8 conversion fork ivory ivorysql CompatibilityCompatibility · Extensions gbdchecksExtensionsExtensionsDatabase health-check functions and views for bloat, locks, query statistics, and privileges. bloat monitoring permissions statistics gbdchecks AdministrationAdministration · Extensions