Search PostgreSQL documentation

orafceExtensionsExtensionsFunctions and operators that emulate a subset of functions and packages from the Oracle RDBMS oracle orafce CompatibilityCompatibility · Extensions orafce_mailExtensionsExtensionsImplementation of utl mail and DBMS MAIL packages attachments compatibility curl curl-library custom function mail oracle orafce postgresql-extension send mail smtp-client user function oraf…Compatibility · Extensions oraplsqlExtensionsExtensionsOracle-compatible procedural SQL language for OpenTenBase. oraplsql CompatibilityCompatibility · Extensions orb_fdwExtensionsExtensionsA foreign data wrapper for Orb pgrx orb_fdw Foreign data wrappersForeign data wrappers · Extensions orc_fdwExtensionsExtensionsForeign data wrapper for reading ORC formatted files fdw file orc orc_fdw Foreign data wrappersForeign data wrappers · Extensions ORDER BYSQL CommandsPG187.5. Sorting Rows (ORDER BY) # After a query has produced an output table (after the select list has been processed) it can optionally be sorted. If sorting is not chosen, the rows will be r…Sorting Rows (ORDER BY) ORDER BY ClauseManual ChaptersPG18ORDER BY Clause The optional ORDER BY clause has this general form: ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] The ORDER BY clause causes the resu…ORDER BY Clause Ordered-Set AggregatesManual ChaptersPG1836.12.3. Ordered-Set Aggregates The aggregates we have been describing so far are “normal” aggregates. PostgreSQL also supports ordered-set aggregates, which differ from normal aggregates in…Ordered-Set Aggregates OrderingManual ChaptersPG188.7.2. Ordering The ordering of the values in an enum type is the order in which the values were listed when the type was created. All standard comparison operators and related aggregate fun…Ordering Ordering OperatorsManual ChaptersPG1836.16.7. Ordering Operators Some index access methods (currently, only GiST and SP-GiST) support the concept of ordering operators. What we have been discussing so far are search operators. …Ordering Operators orgpasscheckExtensionsExtensionsPassword policy enforcement extension for PostgreSQL 16+ database-management database-security enterprise password-policy pgxs postgresql-extension security orgpasscheck SecuritySecurity · Extensions Origin Filter CallbackManual ChaptersPG1847.6.4.7. Origin Filter Callback The optional filter_by_origin_cb callback is called to determine whether data that has been replayed from origin_id is of interest to the output plugin. type…Origin Filter Callback orioledbExtensionsExtensionsOrioleDB, the next generation transactional engine fork oriole orioledb FeaturesFeatures · Extensions orochiExtensionsExtensionsModern HTAP PostgreSQL extension for sharding, time-series, columnar analytics, tiered storage, and vector workloads. analytics htap sharding vector orochi AnalyticsAnalytics · Extensions os_nameExtensionsExtensionsEnumerable mobile os type, stored in a single-byte, fixed-length type. os_name Data typesData types · Extensions osm_fdwExtensionsExtensionsForeign data wrapper for reading OpenStreetMap PBF files fdw osm pbf osm_fdw Foreign data wrappersForeign data wrappers · Extensions osrmintExtensionsExtensionsPostgreSQL route OSRM integration osrmint GeospatialGeospatial · Extensions oss_fdwExtensionsExtensionsAlibaba Cloud OSS foreign data wrapper for reading and writing OSS objects from PostgreSQL-compatible managed services. alibaba-cloud fdw object-storage oss oss_fdw Foreign data wrappersForeign data wrappers · Extensions Other Database ObjectsManual ChaptersPG185.14. Other Database Objects Tables are the central objects in a relational database structure, because they hold your data. But they are not the only objects that exist in a database. Many …Other Database Objects Other DefaultsManual ChaptersPG1819.11.4. Other Defaults dynamic_library_path (string) # If a dynamically loadable module needs to be opened and the file name specified in the CREATE FUNCTION or LOAD command does not have a…Other Defaults Other Planner OptionsManual ChaptersPG1819.7.4. Other Planner Options default_statistics_target (integer) Sets the default statistics target for table columns without a column-specific target set via ALTER TABLE SET STATISTICS. La…Other Planner Options Other TargetsManual ChaptersPG1817.4.4.5. Other Targets clean # Remove all build products test # Run all enabled tests (including contrib) world # Build everything, including documentation help # List important targetsOther Targets Other Things to Watch ForManual ChaptersPG1841.13.2. Other Things to Watch For This section explains a few other things to watch for when porting Oracle PL/SQL functions to PostgreSQL.Other Things to Watch For otletExtensionsExtensionsLocal LLM inference inside PostgreSQL with background workers, queued tasks, receipts, and semantic data operations. pgrx rust otlet_pg AI and vectorsAI and vectors · Extensions otpExtensionsExtensionsImplementation of TOTP compatible with Google Authenticator otp SecuritySecurity · Extensions Out-of-Line, In-Memory TOAST StorageManual ChaptersPG1866.2.2. Out-of-Line, In-Memory TOAST Storage TOAST pointers can point to data that is not on disk, but is elsewhere in the memory of the current server process. Such pointers obviously canno…Out-of-Line, In-Memory TOAST Storage Out-of-Line, On-Disk TOAST StorageManual ChaptersPG1866.2.1. Out-of-Line, On-Disk TOAST Storage If any of the columns of a table are TOAST-able, the table will have an associated TOAST table, whose OID is stored in the table's pg_class.reltoas…Out-of-Line, On-Disk TOAST Storage Output ModesManual ChaptersPG1847.6.3. Output Modes Output plugin callbacks can pass data to the consumer in nearly arbitrary formats. For some use cases, like viewing the changes via SQL, returning data in a data type th…Output Modes Output Plugin CallbacksManual ChaptersPG1847.6.4. Output Plugin Callbacks An output plugin gets notified about changes that are happening via various callbacks it needs to provide. Concurrent transactions are decoded in commit order…Output Plugin Callbacks Output PluginsManual ChaptersPG1847.2.4. Output Plugins Output plugins transform the data from the write-ahead log's internal representation into the format the consumer of a replication slot desires.Output Plugins output_plugin_librariesConfigurationReferenceoutput_plugin_libraries Replication 14 Lists the libraries installed in dynamic_library_path that are also trusted for use as logical output plugins by replication clients. Any logical decod…Configuration · Replication OutputsManual ChaptersPG18Outputs When VERBOSE is specified, ANALYZE emits progress messages to indicate which table is currently being processed. Various statistics about the tables are printed as well.Outputs OutputsManual ChaptersPG18Outputs On successful completion, a COPY command returns a command tag of the form COPY count The count is the number of rows copied. Note psql will print this command tag only if the comman…Outputs OutputsManual ChaptersPG18Outputs On successful completion, a DELETE command returns a command tag of the form DELETE count The count is the number of rows deleted. Note that the number may be less than the number of…Outputs OutputsManual ChaptersPG18Outputs The command tag returned by EXECUTE is that of the prepared statement, and not EXECUTE.Outputs OutputsManual ChaptersPG18Outputs The command's result is a textual description of the plan selected for the statement, optionally annotated with execution statistics. Section 14.1 describes the information provided.Outputs OutputsManual ChaptersPG18Outputs On successful completion, a FETCH command returns a command tag of the form FETCH count The count is the number of rows fetched (possibly zero). Note that in psql, the command tag wi…Outputs OutputsManual ChaptersPG18Outputs On successful completion, an INSERT command returns a command tag of the form INSERT oid count The count is the number of rows inserted or updated. oid is always 0 (it used to be the…Outputs OutputsManual ChaptersPG18Outputs On successful completion, a MERGE command returns a command tag of the form MERGE total_count The total_count is the total number of rows changed (whether inserted, updated, or delet…Outputs OutputsManual ChaptersPG18Outputs On successful completion, a MOVE command returns a command tag of the form MOVE count The count is the number of rows that a FETCH command with the same parameters would have returne…Outputs