Prague PostgreSQL Developer Day 2025 (P2D2 2025) will be held on January 28-29 in Prague, Czech Republic. The conference focuses ...

We are excited to announce the release of [pgspot]( 0.8.1, a new version of our vulnerability checker for PostgreSQL SQL ...

This page lists links to pages for the various teams and committees that comprise the governance hierarchy of the project. Please see the individual linked pages for more information about each group, ...

All variables used in a block must be declared in the declarations section of the block. (The only exceptions are that the loop variable of a FOR loop iterating over a range of integer values is ...

If you have pattern matching needs that go beyond this, consider writing a user-defined function in Perl or Tcl. While most regular-expression searches can be executed very quickly, regular ...

This event is recognised under the community event guidelines. PostgreSQL Conference Europe 2024 will be held on October 22-25 in Athens, Greece at the Divani Caravel Hotel. At the biggest PostgreSQL ...

pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/restore ...

PostgreSQL manages database access permissions using the concept of roles. A role can be thought of as either a database user, or a group of database users, depending on how the role is set up. Roles ...

Indexes can also be used to enforce uniqueness of a column's value, or the uniqueness of the combined values of more than one column. Currently, only B-tree indexes can be declared unique. When an ...

PostgreSQL manages database access permissions using the concept of roles. A role can be thought of as either a database user, or a group of database users, depending on how the role is set up. Roles ...

Table 9.54 shows the specialized operators available for array types. In addition to those, the usual comparison operators shown in Table 9.1 are available for arrays. The comparison operators compare ...

Chris Travers (Chair) chris.travers (at) gmail.com Chris Travers has 25 years of experience with PostgreSQL in many roles from DBA to developer and is active on commitfiests. He also actively presents ...