Search PostgreSQL documentation

Passing Query Parameters Using an SQLDAManual ChaptersPG1834.7.2.3. Passing Query Parameters Using an SQLDA The general steps to use an SQLDA to pass input parameters to a prepared query are: Create a prepared query (prepared statement) Declare an …Passing Query Parameters Using an SQLDA passwd-fdwExtensionsExtensionsForeign data wrapper for Unix/Linux passwd and group databases. passwd_fdw Foreign data wrappersForeign data wrappers · Extensions passwordCommand-line ToolsPG18password Password to be used if the server demands password authentication.Database Connection Control Functions › Parameter Key Words passwordExtensionsExtensionsPostgreSQL data type for passwords password Data typesData types · Extensions Password AuthenticationManual ChaptersPG1820.5. Password Authentication There are several password-based authentication methods. These methods operate similarly but differ in how the users' passwords are stored on the server and how…Password Authentication Password Hashing FunctionsManual ChaptersPG18F.26.2. Password Hashing Functions The functions crypt() and gen_salt() are specifically designed for hashing passwords. crypt() does the hashing and gen_salt() prepares algorithm parameters…Password Hashing Functions password_encryptionConfigurationReferencepassword_encryption Connections and Authentication 10 When a password is specified in CREATE ROLE or ALTER ROLE, this parameter determines the algorithm to use to encrypt the password. The d…Configuration · Connections and Authentication password_expiration_warning_thresholdConfigurationReferencepassword_expiration_warning_threshold Connections and Authentication 19 When this parameter is greater than zero, the server will emit a WARNING upon successful password authentication if le…Configuration · Connections and Authentication password_profileExtensionsExtensionspassword_profile: Advanced password security and policy enforcement password_profile SecuritySecurity · Extensions passwordcheckExtensionsPG18F.24. passwordcheck — verify password strength The passwordcheck module checks users' passwords whenever they are set with CREATE ROLE or ALTER ROLE. If a password is considered too weak, it…passwordcheck — verify password strength passwordcheck — verify password strengthManual ChaptersPG18F.24. passwordcheck — verify password strength The passwordcheck module checks users' passwords whenever they are set with CREATE ROLE or ALTER ROLE. If a password is considered too weak, it…passwordcheck — verify password strength passwordcheck_cracklibExtensionsExtensionsStrengthen PostgreSQL user password checks with cracklib passwordcheck_cracklib SecuritySecurity · Extensions passwordpolicyExtensionsExtensionsDynamically configurable PostgreSQL password complexity checks. password security preload passwordpolicy SecuritySecurity · Extensions pathData TypesPG18path geometric path on a planeData Types pathFunctionsReferencepath Geometric Functions And Operators 10 polygon to path path ( polygon ) → path polygon to path 11 12 13 Converts polygon to a closed path with the same list of points. path ( polygon ) → …Functions · Geometric Functions And Operators pathman_shardingExtensionsExtensionsImproved sharding for pg_pathman. fdw hash partitioning pathman range sharding pathman_sharding AnalyticsAnalytics · Extensions pathprobeExtensionsExtensionsPostgreSQL planner path probing extension for planner-aware SQL agents database hypothetical-indexes model-based-testing performance planner postgres postgres-extension postgresql query-opti…Monitoring · Extensions PathsManual ChaptersPG188.8.5. Paths Paths are represented by lists of connected points. Paths can be open, where the first and last points in the list are considered not connected, or closed, where the first and l…Paths patientsExtensionsExtensionspatients extension dependency-closure patients source-only sql patients FeaturesFeatures · Extensions Pattern MatchingManual ChaptersPG189.7. Pattern Matching There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQL LIKE operator, the more recent SIMILAR TO operator (added in SQL:199…Pattern Matching PatternsManual ChaptersPG18Patterns The various \d commands accept a pattern parameter to specify the object name(s) to be displayed. In the simplest case, a pattern is just the exact name of the object. The character…Patterns pavesExtensionsExtensionsFiltered L2 vector search with CPU and optional GPU execution vector filtered-search gpu research paves AI and vectorsAI and vectors · Extensions payment_extExtensionsExtensionsPayment-service transaction markers and a LISTEN/NOTIFY background worker for a marketplace prototype. payment_ext FeaturesFeatures · Extensions pbloompgExtensionsExtensionsportable bloom filter, create, serialize, query across Go, Rust, Postgres pbloompg Functions and aggregatesFunctions and aggregates · Extensions pboutputExtensionsExtensionsBinary logical-decoding output plugin that encodes PostgreSQL changes as Protocol Buffers. pboutput Replication and streamsReplication and streams · Extensions pcg_randomExtensionsExtensionsPCG pseudo-random number generator functions for PostgreSQL. pgsql_pcg_random Functions and aggregatesFunctions and aggregates · Extensions pcloseFunctionsReferencepclose Geometric Functions And Operators 10 convert path to closed pclose ( path ) → path convert path to closed 11 12 13 Converts path to closed form. pclose ( path ) → path Converts path t…Functions · Geometric Functions And Operators pcsa_counterExtensionsExtensionsAggregation functions and data type for distinct estimation based on PCSA. aggregate count distinct estimate pcsa sampling distinct_estimators Functions and aggregatesFunctions and aggregates · Extensions PDFManual ChaptersPG18J.3.3. PDF To produce a PDF rendition of the documentation using FOP, you can use one of the following commands, depending on the preferred paper format: For A4 format: doc/src/sgml$ make po…PDF ped25519ExtensionsExtensionsEd25519 signing and verification functions implemented in Rust with pgrx. pgrx ped25519 SecuritySecurity · Extensions Peer AuthenticationManual ChaptersPG1820.9. Peer Authentication The peer authentication method works by obtaining the client's operating system user name from the kernel and using it as the allowed database user name (with optio…Peer Authentication Per-Command PoliciesManual ChaptersPG18Per-Command Policies ALL Using ALL for a policy means that it will apply to all commands, regardless of the type of command. If an ALL policy exists and more specific policies exist, then bo…Per-Command Policies Per-Statement ReportManual ChaptersPG18Per-Statement Report With the -r option, pgbench collects the following statistics for each statement: latency — elapsed transaction time for each statement. pgbench reports an average value…Per-Statement Report Per-Transaction LoggingManual ChaptersPG18Per-Transaction Logging With the -l option (but without the --aggregate-interval option), pgbench writes information about each transaction to a log file. The log file will be named prefix.n…Per-Transaction Logging percent_rankFunctionsReferencepercent_rank Aggregate Functions 10 relative rank of the hypothetical row, ranging from 0 to 1 percent_rank ( args ) WITHIN GROUP (ORDER BY sorted_args) → double precision relative rank of t…Functions · Aggregate Functions percentile_contFunctionsReferencepercentile_cont Aggregate Functions 10 continuous percentile: returns a value corresponding to the specified fraction in the ordering, interpolating between adjacent input items if needed pe…Functions · Aggregate Functions percentile_discFunctionsReferencepercentile_disc Aggregate Functions 10 discrete percentile: returns the first input value whose position in the ordering equals or exceeds the specified fraction percentile_disc ( fraction )…Functions · Aggregate Functions percona_pg_telemetryExtensionsExtensionsPercona telemetry extension for PostgreSQL percona percona-distribution pg postgresql telemetry telemetry-collection percona_pg_telemetry MonitoringMonitoring · Extensions Performance TipsManual ChaptersPG18Chapter 14. Performance Tips Query performance can be affected by many things. Some of these can be controlled by the user, while others are fundamental to the underlying design of the syste…Performance Tips periodsExtensionsExtensionsProvide Standard SQL functionality for PERIODs and SYSTEM VERSIONING periods Time seriesTime series · Extensions