Search PostgreSQL documentation

oblivpg_fdwExtensionsExtensionsOblivious foreign data wrapper for table access backed by trusted hardware and ORAM fdw oram privacy sgx oblivpg_ftw Foreign data wrappersForeign data wrappers · Extensions obs_fdwExtensionsExtensionsHuawei Cloud OBS foreign data wrapper extension listed for RDS PostgreSQL. fdw huawei object-storage obs obs_fdw Foreign data wrappersForeign data wrappers · Extensions Obsolete Functions for COPYManual ChaptersPG1832.10.3. Obsolete Functions for COPY These functions represent older methods of handling COPY. Although they still work, they are deprecated due to poor error handling, inconvenient methods …Obsolete Functions for COPY Obsolete Functions for Sending Cancel RequestsManual ChaptersPG1832.7.2. Obsolete Functions for Sending Cancel Requests These functions represent older methods of sending cancel requests. Although they still work, they are deprecated due to not sending th…Obsolete Functions for Sending Cancel Requests Obsolete or Renamed FeaturesManual ChaptersPG18Appendix O. Obsolete or Renamed Features Functionality is sometimes removed from PostgreSQL, feature, setting and file names sometimes change, or documentation moves to different places. Thi…Obsolete or Renamed Features Obtaining Execution Location InformationManual ChaptersPG1841.6.9. Obtaining Execution Location Information The GET DIAGNOSTICS command, previously described in Section 41.5.5, retrieves information about current execution state (whereas the GET STA…Obtaining Execution Location Information Obtaining Information about an ErrorManual ChaptersPG1841.6.8.1. Obtaining Information about an Error Exception handlers frequently need to identify the specific error that occurred. There are two ways to get information about the current except…Obtaining Information about an Error Obtaining the Result StatusManual ChaptersPG1841.5.5. Obtaining the Result Status There are several ways to determine the effect of a command. The first method is to use the GET DIAGNOSTICS command, which has the form: GET [ CURRENT ] D…Obtaining the Result Status Obtaining the Seek Position of a Large ObjectManual ChaptersPG1833.3.8. Obtaining the Seek Position of a Large Object To obtain the current read or write location of a large object descriptor, call int lo_tell(PGconn *conn, int fd); If there is an error,…Obtaining the Seek Position of a Large Object ocgeo_fdwExtensionsExtensionsForeign data wrapper for the OpenCageData API curl fdw geocoding json opencage ocgeo_fdw Foreign data wrappersForeign data wrappers · Extensions octet_lengthFunctionsReferenceoctet_length String Functions And Operators 10 Number of bytes in string octet_length ( string ) → int Number of bytes in string 11 12 13 Returns number of bytes in the string. octet_length …Functions · String Functions And Operators odbc_fdwExtensionsExtensionsForeign data wrapper for accessing remote databases using ODBC odbc_fdw Foreign data wrappersForeign data wrappers · Extensions ofarm_ed25519ExtensionsExtensionsOFARM verification-only strict Ed25519 primitive ofarm_ed25519 SecuritySecurity · Extensions Off-line Enabling of ChecksumsManual ChaptersPG1828.2.1. Off-line Enabling of Checksums The pg_checksums application can be used to enable or disable data checksums, as well as verify checksums, on an offline cluster.Off-line Enabling of Checksums OFFSETSQL CommandsPG187.6. LIMIT and OFFSET # LIMIT and OFFSET allow you to retrieve just a portion of the rows that are generated by the rest of the query: SELECT select_list FROM table_expression [ ORDER BY ...…LIMIT and OFFSET ogaiExtensionsExtensionsOGAI - AI vectorization and search framework for openGauss ogai AI and vectorsAI and vectors · Extensions ogr_fdwExtensionsExtensionsforeign-data wrapper for GIS data access ogr_fdw GeospatialGeospatial · Extensions OID AssignmentManual ChaptersPG1868.2.2. OID Assignment A catalog row appearing in the initial data can be given a manually-assigned OID by writing an oid => nnnn metadata field. Furthermore, if an OID is assigned, a C macr…OID Assignment OID Reference LookupManual ChaptersPG1868.2.3. OID Reference Lookup In principle, cross-references from one initial catalog row to another could be written just by writing the preassigned OID of the referenced row in the referenc…OID Reference Lookup oid2nameManual ChaptersPG18oid2name oid2name — resolve OIDs and file nodes in a PostgreSQL data directory Synopsis oid2name [option...]oid2name oidc_validatorExtensionsExtensionsPostgreSQL 18 OIDC bearer-token validator plugin written in Rust pgrx nil-lic pg_oidc_validator_rust SecuritySecurity · Extensions OidGenWait EventsReferenceOidGen LWLock 10 Waiting to allocate or assign an OID. 11 12 13 Waiting to allocate a new OID. 14 15 16 17 18 19 20 9.6 A brief sample is normal around short internal critical sections. Inve…Wait Events · LWLock old_snapshotExtensionsExtensionsutilities in support of old_snapshot_threshold old_snapshot AdministrationAdministration · Extensions old_snapshot_thresholdConfigurationReferenceold_snapshot_threshold Resource Usage 10 Sets the minimum time that a snapshot can be used without risk of a snapshot too old error occurring when using the snapshot. This parameter can only…Configuration · Resource Usage OldSnapshotTimeMapWait EventsReferenceOldSnapshotTimeMap LWLock 10 Waiting to read or update old snapshot control information. 11 12 13 14 15 16 9.6 A brief sample is normal around short internal critical sections. Investigate w…Wait Events · LWLock olirice-asciiplotExtensionsExtensionsA Toy ASCII Plotting Library database.dev tle olirice-asciiplot UtilitiesUtilities · Extensions olirice-read_onceExtensionsExtensionsSend messages that can only be read once database.dev tle olirice-read_once FeaturesFeatures · Extensions ollamaExtensionsExtensionsOllama client for PostgreSQL ai http llm ollama rag ollama AI and vectorsAI and vectors · Extensions Omitted FROM ClausesManual ChaptersPG18Omitted FROM Clauses PostgreSQL allows one to omit the FROM clause. It has a straightforward use to compute the results of simple expressions: SELECT 2+2; ?column? ---------- 4 Some other SQ…Omitted FROM Clauses Omitting Sub-SELECT Aliases in FROMManual ChaptersPG18Omitting Sub-SELECT Aliases in FROM According to the SQL standard, a sub-SELECT in the FROM list must have an alias. In PostgreSQL, this alias may be omitted.Omitting Sub-SELECT Aliases in FROM Omitting the AS Key WordManual ChaptersPG18Omitting the AS Key Word In the SQL standard, the optional key word AS can be omitted before an output column name whenever the new column name is a valid column name (that is, not the same …Omitting the AS Key Word omniExtensionsExtensionsAdvanced adapter for Postgres extensions omnigres FeaturesFeatures · Extensions omni_authExtensionsExtensionsBasic session management omnigres FeaturesFeatures · Extensions omni_awsExtensionsExtensionsAmazon Web Services APIs (S3) omnigres FeaturesFeatures · Extensions omni_cloudeventsExtensionsExtensionsCloudEvents support omnigres FeaturesFeatures · Extensions omni_containersExtensionsExtensionsDocker container management omnigres FeaturesFeatures · Extensions omni_credentialsExtensionsExtensionsApplication credential management omnigres FeaturesFeatures · Extensions omni_csvExtensionsExtensionsCSV toolkit omni_csv FeaturesFeatures · Extensions omni_datasetsExtensionsExtensionsDataset provisioning omni_datasets FeaturesFeatures · Extensions omni_emailExtensionsExtensionsE-mail framework omnigres FeaturesFeatures · Extensions