Search PostgreSQL documentation

asciiFunctionsReferenceascii String Functions And Operators 10 ASCII code of the first character of the argument. For UTF8 returns the Unicode code point of the character. For other multibyte encodings, the argume…Functions · String Functions And Operators asghonim@pgho_inboxExtensionsExtensionsInbound contact and inbox framework with validation, rate limiting, spam scoring, workflow state, and notification events. database.dev tle asghonim@pgho_inbox FeaturesFeatures · Extensions asinFunctionsReferenceasin Mathematical Functions And Operators 10 inverse sine asin ( x ) inverse sine 11 12 13 Inverse sine, result in radians asin ( double precision ) → double precision Inverse sine, result i…Functions · Mathematical Functions And Operators asindFunctionsReferenceasind Mathematical Functions And Operators 10 inverse sine asind ( x ) inverse sine 11 12 13 Inverse sine, result in degrees asind ( double precision ) → double precision Inverse sine, resul…Functions · Mathematical Functions And Operators asinhFunctionsReferenceasinh Mathematical Functions And Operators 12 inverse hyperbolic sine asinh ( x ) inverse hyperbolic sine 13 Inverse hyperbolic sine asinh ( double precision ) → double precision Inverse hyp…Functions · Mathematical Functions And Operators asn1oidExtensionsExtensionsasn1oid extension asn1oid Data typesData types · Extensions AssignmentManual ChaptersPG1841.5.1. Assignment An assignment of a value to a PL/pgSQL variable is written as: variable { := | = } expression; As explained previously, the expression in such a statement is evaluated by …Assignment ast_postgisExtensionsExtensionsAdvanced spatial data types and spatial integrity constraints for PostGIS. gis postgis spatial ast_postgis GeospatialGeospatial · Extensions astrocatExtensionsExtensionsPostgreSQL extension for indexing astronomical catalogues with spherical point and circle types, GiST indexing, radial queries, and k-nearest-neighbor ordering. astronomy gist indexing knn a…Geospatial · Extensions async_responseExtensionsExtensionsPostgreSQL - Multiple asynchronous responses in one query async-response postgresql postgresql-extension redis async_response UtilitiesUtilities · Extensions Asynchronous Command ProcessingManual ChaptersPG1832.4. Asynchronous Command Processing The PQexec function is adequate for submitting commands in normal, synchronous applications. It has a few deficiencies, however, that can be of importan…Asynchronous Command Processing Asynchronous CommitManual ChaptersPG1828.4. Asynchronous Commit Asynchronous commit is an option that allows transactions to complete more quickly, at the cost that the most recent transactions may be lost if the database should…Asynchronous Commit Asynchronous Execution OptionsManual ChaptersPG18F.38.1.5. Asynchronous Execution Options postgres_fdw supports asynchronous execution, which runs multiple parts of an Append node concurrently rather than serially to improve performance. T…Asynchronous Execution Options Asynchronous NotificationManual ChaptersPG1832.9. Asynchronous Notification PostgreSQL offers asynchronous notification via the LISTEN and NOTIFY commands. A client session registers its interest in a particular notification channel w…Asynchronous Notification Asynchronous OperationsManual ChaptersPG1854.2.7. Asynchronous Operations There are several cases in which the backend will send messages that are not specifically prompted by the frontend's command stream. Frontends must be prepare…Asynchronous Operations AT LOCALSQL CommandsPG189.9.4. AT TIME ZONE and AT LOCAL # The AT TIME ZONE operator converts time stamp without time zone to/from time stamp with time zone, and time with time zone values to different time zones. …Date/Time Functions and Operators › AT TIME ZONE and AT LOCAL AT TIME ZONESQL CommandsPG189.9.4. AT TIME ZONE and AT LOCAL # The AT TIME ZONE operator converts time stamp without time zone to/from time stamp with time zone, and time with time zone values to different time zones. …Date/Time Functions and Operators › AT TIME ZONE and AT LOCAL AT TIME ZONE and AT LOCALManual ChaptersPG189.9.4. AT TIME ZONE and AT LOCAL The AT TIME ZONE operator converts time stamp without time zone to/from time stamp with time zone, and time with time zone values to different time zones. Ta…AT TIME ZONE and AT LOCAL atanFunctionsReferenceatan Mathematical Functions And Operators 10 inverse tangent atan ( x ) inverse tangent 11 12 13 Inverse tangent, result in radians atan ( double precision ) → double precision Inverse tange…Functions · Mathematical Functions And Operators atan2FunctionsReferenceatan2 Mathematical Functions And Operators 10 inverse tangent of y/x atan2 ( y, x ) inverse tangent of y/x 11 12 13 Inverse tangent of y/x, result in radians atan2 ( y double precision, x do…Functions · Mathematical Functions And Operators atan2dFunctionsReferenceatan2d Mathematical Functions And Operators 10 inverse tangent of y/x atan2d ( y, x ) inverse tangent of y/x 11 12 13 Inverse tangent of y/x, result in degrees atan2d ( y double precision, x…Functions · Mathematical Functions And Operators atandFunctionsReferenceatand Mathematical Functions And Operators 10 inverse tangent atand ( x ) inverse tangent 11 12 13 Inverse tangent, result in degrees atand ( double precision ) → double precision Inverse ta…Functions · Mathematical Functions And Operators atanhFunctionsReferenceatanh Mathematical Functions And Operators 12 inverse hyperbolic tangent atanh ( x ) inverse hyperbolic tangent 13 Inverse hyperbolic tangent atanh ( double precision ) → double precision In…Functions · Mathematical Functions And Operators attributesManual ChaptersPG1835.6. attributes The view attributes contains information about the attributes of composite data types defined in the database. (Note that the view does not give information about table colu…attributes auditExtensionsExtensionsAudits insert, update, and delete operations on PostgreSQL tables. audit trigger pg_audit SecuritySecurity · Extensions audit_streamExtensionsExtensionsPostgres extension that emits audit-stream-py-compatible governance events on watched table CRUD via pg notify, plus a Python LISTEN bridge daemon. The database-tier governance producer for …Security · Extensions auditoriaExtensionsExtensionsPostgreSQL auditing extension. auditoria SecuritySecurity · Extensions aurora_stat_utilsExtensionsExtensionsAurora PostgreSQL statistics utility functions for wait-event reporting. aurora aws statistics wait-events aurora_stat_utils MonitoringMonitoring · Extensions auth0ExtensionsExtensionsAuth0 Management API client for PostgreSQL. auth0 identity management-api auth0 SecuritySecurity · Extensions auth_delayExtensionsPG18F.2. auth_delay — pause on authentication failure auth_delay causes the server to pause briefly before reporting authentication failure, to make brute-force attacks on database passwords mor…auth_delay — pause on authentication failure auth_delay — pause on authentication failureManual ChaptersPG18F.2. auth_delay — pause on authentication failure auth_delay causes the server to pause briefly before reporting authentication failure, to make brute-force attacks on database passwords mor…auth_delay — pause on authentication failure Authdata HooksManual ChaptersPG1832.20.1. Authdata Hooks The behavior of the OAuth flow may be modified or replaced by a client using the following hook API: PQsetAuthDataHook # Sets the PGauthDataHook, overriding libpq's h…Authdata Hooks AuthenticationManual ChaptersPG1819.3.3. Authentication authentication_timeout (integer) # Maximum amount of time allowed to complete client authentication. If a would-be client has not completed the authentication protocol…Authentication AuthenticationManual ChaptersPG1826.2.5.1. Authentication It is very important that the access privileges for replication be set up so that only trusted users can read the WAL stream, because it is easy to extract privilege…Authentication Authentication MethodsManual ChaptersPG1820.3. Authentication Methods PostgreSQL provides various methods for authenticating users: Trust authentication, which simply trusts that users are who they say they are. Password authentica…Authentication Methods Authentication ProblemsManual ChaptersPG1820.16. Authentication Problems Authentication failures and related problems generally manifest themselves through error messages like the following: FATAL: no pg_hba.conf entry for host "123…Authentication Problems authentication_timeoutConfigurationReferenceauthentication_timeout Connections and Authentication 10 Maximum time to complete client authentication, in seconds. If a would-be client has not completed the authentication protocol in thi…Configuration · Connections and Authentication AuthorManual ChaptersPG18F.2.2. Author KaiGai Kohei <kaigai@ak.jp.nec.com>Author AuthorManual ChaptersPG18F.3.3. Author Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>Author AuthorManual ChaptersPG18F.4.2. Author Robert Haas <rhaas@postgresql.org>Author