Search PostgreSQL documentation

GROUPING SETSSQL CommandsPG187.2.4. GROUPING SETS, CUBE, and ROLLUP # More complex grouping operations than those described above are possible using the concept of grouping sets. The data selected by the FROM and WHERE …Table Expressions › GROUPING SETS, CUBE, and ROLLUP GROUPING SETS, CUBE, and ROLLUPManual ChaptersPG187.2.4. GROUPING SETS, CUBE, and ROLLUP More complex grouping operations than those described above are possible using the concept of grouping sets. The data selected by the FROM and WHERE cl…GROUPING SETS, CUBE, and ROLLUP grpc_fdwExtensionsExtensionsForeign data wrapper that delegates table operations to services over gRPC. grpc_fdw Foreign data wrappersForeign data wrappers · Extensions gsheetsExtensionsExtensionsRead and write Google Sheets from PostgreSQL. etl google-sheets http gsheets Replication and streamsReplication and streams · Extensions gss_accept_delegationConfigurationReferencegss_accept_delegation Connections and Authentication 16 Sets whether GSSAPI delegation should be accepted from the client. The default is off meaning credentials from the client will not be …Configuration · Connections and Authentication GSSAPI AuthenticationManual ChaptersPG1820.6. GSSAPI Authentication GSSAPI is an industry-standard protocol for secure authentication defined in RFC 2743. PostgreSQL supports GSSAPI for authentication, communications encryption, o…GSSAPI Authentication GSSAPI Session EncryptionManual ChaptersPG1854.2.11. GSSAPI Session Encryption If PostgreSQL was built with GSSAPI support, frontend/backend communications can be encrypted using GSSAPI. This provides communication security in environ…GSSAPI Session Encryption gsscodeExtensionsExtensionsCompact indexed type for UK ONS and GSS geography codes gss ons geography uk statistics datatype prefix gsscode Data typesData types · Extensions gsscode_ons_refreshExtensionsExtensionsOptional in-database refresh for the gsscode geography-type registry gss ons geography registry http refresh gsscode Data typesData types · Extensions gssdelegationCommand-line ToolsPG18gssdelegation Forward (delegate) GSS credentials to the server. The default is 0 which means credentials will not be forwarded to the server. Set this to 1 to have credentials forwarded when…Database Connection Control Functions › Parameter Key Words gssencmodeCommand-line ToolsPG18gssencmode This option determines whether or with what priority a secure GSS TCP/IP connection will be negotiated with the server. There are three modes: disable only try a non-GSSAPI-encryp…Database Connection Control Functions › Parameter Key Words gsslibCommand-line ToolsPG18gsslib GSS library to use for GSSAPI authentication. Currently this is disregarded except on Windows builds that include both GSSAPI and SSPI support. In that case, set this to gssapi to cau…Database Connection Control Functions › Parameter Key Words GssOpenServerWait EventsReferenceGssOpenServer Client 12 Waiting to read data from the client while establishing the GSSAPI session. 13 Waiting to read data from the client while establishing a GSSAPI session. 14 15 16 17 1…Wait Events · Client gtables_fdwExtensionsExtensionsGlobal tables across FDW API fdw global-tables preload gtables_fdw Foreign data wrappersForeign data wrappers · Extensions GUC ParametersManual ChaptersPG18F.35.3. GUC Parameters pg_trgm.similarity_threshold (real) # Sets the current similarity threshold that is used by the % operator. The threshold must be between 0 and 1 (default is 0.3). pg_…GUC Parameters GUC ParametersManual ChaptersPG18F.40.4. GUC Parameters sepgsql.permissive (boolean) # This parameter enables sepgsql to function in permissive mode, regardless of the system setting. The default is off. This parameter can …GUC Parameters gunzipExtensionsExtensionsDecompress gzip-compressed bytea values to text or bytea. compression gzip gunzip_pg UtilitiesUtilities · Extensions gzipExtensionsExtensionsgzip and gunzip functions. pg_gzip UtilitiesUtilities · Extensions h3ExtensionsExtensionsH3 bindings for PostgreSQL pg_h3 GeospatialGeospatial · Extensions h3_postgisExtensionsExtensionsH3 PostGIS integration pg_h3 GeospatialGeospatial · Extensions hammingExtensionsExtensionsRust/pgrx extension providing a Hamming-distance operator for bytea plus an unfinished experimental IVF index access method. bytea hamming index ivf pgrx hamming AI and vectorsAI and vectors · Extensions hamming_distanceExtensionsExtensionsHamming distance and similarity functions for hexadecimal feature-vector strings. feature-vector hamming-distance similarity hamming_distance AI and vectorsAI and vectors · Extensions hamradioExtensionsExtensionsham radio extension ham-radio types postgresql_hamradio Data typesData types · Extensions Handling a Table Rewrite EventManual ChaptersPG189.30.3. Handling a Table Rewrite Event The functions shown in Table 9.111 provide information about a table for which a table_rewrite event has just been called. If called in any other conte…Handling a Table Rewrite Event Handling Character StringsManual ChaptersPG1834.4.4.1. Handling Character Strings To handle SQL character string data types, such as varchar and text, there are two possible ways to declare the host variables. One way is using char[], …Handling Character Strings Handling Large DatabasesManual ChaptersPG1825.1.3. Handling Large Databases Some operating systems have maximum file size limits that cause problems when creating large pg_dump output files. Fortunately, pg_dump can write to the stan…Handling Large Databases Handling Nonprimitive SQL Data TypesManual ChaptersPG1834.4.5. Handling Nonprimitive SQL Data Types This section contains information on how to handle nonscalar and user-defined SQL-level data types in ECPG applications. Note that this is distin…Handling Nonprimitive SQL Data Types Handling of Invalid or Ambiguous TimestampsManual ChaptersPG18B.2. Handling of Invalid or Ambiguous Timestamps Ordinarily, if a date/time string is syntactically valid but contains out-of-range field values, an error will be thrown. For example, input …Handling of Invalid or Ambiguous Timestamps Handling of Quotation MarksManual ChaptersPG1841.12.1. Handling of Quotation Marks The code of a PL/pgSQL function is specified in CREATE FUNCTION as a string literal. If you write the string literal in the ordinary way with surrounding…Handling of Quotation Marks Handling Query ConflictsManual ChaptersPG1826.4.2. Handling Query Conflicts The primary and standby servers are in many ways loosely connected. Actions on the primary will have an effect on the standby. As a result, there is potentia…Handling Query Conflicts hartonomousExtensionsExtensionsHartonomous substrate — schemas, types, tables, BLAKE3, S^3 geometry, traversal, UCD/UCA atoms hartonomous FeaturesFeatures · Extensions has_any_column_privilegeFunctionsReferencehas_any_column_privilege System Information Functions And Operators 10 does user have privilege for any column of table has_any_column_privilege ( user, table, privilege ) → boolean does use…Functions · System Information Functions And Operators has_column_privilegeFunctionsReferencehas_column_privilege System Information Functions And Operators 10 does user have privilege for column has_column_privilege ( user, table, column, privilege ) → boolean does user have privil…Functions · System Information Functions And Operators has_database_privilegeFunctionsReferencehas_database_privilege System Information Functions And Operators 10 does user have privilege for database has_database_privilege ( user, database, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators has_foreign_data_wrapper_privilegeFunctionsReferencehas_foreign_data_wrapper_privilege System Information Functions And Operators 10 does user have privilege for foreign-data wrapper has_foreign_data_wrapper_privilege ( user, fdw, privilege )…Functions · System Information Functions And Operators has_function_privilegeFunctionsReferencehas_function_privilege System Information Functions And Operators 10 does user have privilege for function has_function_privilege ( user, function, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators has_language_privilegeFunctionsReferencehas_language_privilege System Information Functions And Operators 10 does user have privilege for language has_language_privilege ( user, language, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators has_largeobject_privilegeFunctionsReferencehas_largeobject_privilege System Information Functions And Operators 18 Does user have privilege for large object? Allowable privilege types are SELECT and UPDATE. has_largeobject_privilege …Functions · System Information Functions And Operators has_parameter_privilegeFunctionsReferencehas_parameter_privilege System Information Functions And Operators 15 Does user have privilege for configuration parameter? The parameter name is case-insensitive. Allowable privilege types …Functions · System Information Functions And Operators has_schema_privilegeFunctionsReferencehas_schema_privilege System Information Functions And Operators 10 does user have privilege for schema has_schema_privilege ( user, schema, privilege ) → boolean does user have privilege for…Functions · System Information Functions And Operators