Search PostgreSQL documentation

odbc_fdwExtensionsExtensionsForeign data wrappers · ExtensionsForeign data wrapper for accessing remote databases using ODBC odbc_fdw Foreign data wrappers ofarm_ed25519ExtensionsExtensionsSecurity · ExtensionsOFARM verification-only strict Ed25519 primitive ofarm_ed25519 Security Off-line Enabling of ChecksumsManual ChaptersPG18Data ChecksumsThe pg_checksums application can be used to enable or disable data checksums, as well as verify checksums, on an offline cluster. OFFSETSQL CommandsPG18LIMIT and OFFSET7.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 ...… ogaiExtensionsExtensionsAI and vectors · ExtensionsAI vectorization and search framework for openGauss ogai AI and vectors ogr_fdwExtensionsExtensionsGeospatial · Extensionsforeign-data wrapper for GIS data access ogr_fdw Geospatial OID AssignmentManual ChaptersPG18System Catalog Initial DataA 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 macro for that OID can be c… OID Reference LookupManual ChaptersPG18System Catalog Initial DataIn 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 referencing field. However, that is a… oid2nameManual ChaptersPG18resolve OIDs and file nodes in a PostgreSQL data directory Synopsis oid2name [option...] oidc_validatorExtensionsExtensionsSecurity · ExtensionsPostgreSQL 18 OIDC bearer-token validator plugin written in Rust pgrx nil-lic pg_oidc_validator_rust Security old_snapshotExtensionsExtensionsAdministration · Extensionsutilities in support of old_snapshot_threshold old_snapshot Administration olirice-asciiplotExtensionsExtensionsUtilities · ExtensionsA Toy ASCII Plotting Library database.dev tle olirice-asciiplot Utilities olirice-read_onceExtensionsExtensionsFeatures · ExtensionsSend messages that can only be read once database.dev tle olirice-read_once Features ollamaExtensionsExtensionsAI and vectors · Extensionsclient for PostgreSQL ai http llm ollama rag ollama AI and vectors Omitted FROM ClausesManual ChaptersPG18SELECTPostgreSQL 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 SQL databases cannot do… Omitting Sub-SELECT Aliases in FROMManual ChaptersPG18SELECTAccording to the SQL standard, a sub-SELECT in the FROM list must have an alias. In PostgreSQL, this alias may be omitted. Omitting the AS Key WordManual ChaptersPG18SELECTIn 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 as any reserved keyword).… omniExtensionsExtensionsFeatures · ExtensionsAdvanced adapter for Postgres extensions omnigres Features omni_authExtensionsExtensionsFeatures · ExtensionsBasic session management omnigres Features omni_awsExtensionsExtensionsFeatures · ExtensionsAmazon Web Services APIs (S3) omnigres Features omni_cloudeventsExtensionsExtensionsFeatures · ExtensionsCloudEvents support omnigres Features omni_containersExtensionsExtensionsFeatures · ExtensionsDocker container management omnigres Features omni_credentialsExtensionsExtensionsFeatures · ExtensionsApplication credential management omnigres Features omni_csvExtensionsExtensionsFeatures · ExtensionsCSV toolkit omni_csv Features omni_datasetsExtensionsExtensionsFeatures · ExtensionsDataset provisioning omni_datasets Features omni_emailExtensionsExtensionsFeatures · ExtensionsE-mail framework omnigres Features omni_gitExtensionsExtensionsCompatibility · ExtensionsA PostgreSQL extension that stores git repositories in database tables and serves the git smart HTTP protocol, turning Postgres into a git remote. omni_git Compatibility omni_httpExtensionsExtensionsFeatures · ExtensionsBasic HTTP types omnigres Features omni_httpcExtensionsExtensionsFeatures · ExtensionsHTTP client omnigres Features omni_httpdExtensionsExtensionsFeatures · ExtensionsHTTP server omnigres Features omni_idExtensionsExtensionsFeatures · ExtensionsIdentity types omnigres Features omni_jsonExtensionsExtensionsFeatures · ExtensionsJSON toolkit omnigres Features omni_kubeExtensionsExtensionsFeatures · ExtensionsKubernetes (k8s) integration omnigres Features omni_ledgerExtensionsExtensionsFeatures · ExtensionsFinancial ledger omnigres Features omni_manifestExtensionsExtensionsFeatures · ExtensionsPackage installation manifests omnigres Features omni_mimetypesExtensionsExtensionsFeatures · ExtensionsMIME types omnigres Features omni_osExtensionsExtensionsFeatures · ExtensionsOperating system integration omnigres Features omni_polyfillExtensionsExtensionsFeatures · ExtensionsPostgres API polyfills omnigres Features omni_pythonExtensionsExtensionsFeatures · ExtensionsFirst-class Python support omnigres Features omni_regexExtensionsExtensionsFeatures · ExtensionsPCRE-compatible regular expressions omnigres Features