PostgreSQL7d
Call for Proposals is open for POSETTE: An Event for Postgres 2025!
The CFP is now open & will close on Feb 9, 2025! The 4th annual event called POSETTE: An Event for Postgres will happen Jun 10-12, 2025 and the Call for Speakers is now open—unt ...
PostgreSQL7d
PGConf.dev 2025 - Call for Speakers and Sponsors
PGConf.dev 2025]( (May 13-16, 2025, Montreal, CA), aka [PostgreSQL Development Conference 2025]( is an event where users, developers, and community ...
PostgreSQL8d
PGDay/MED Schedule and Registration
We're pleased to announce that we published the schedule of the PGDay/MED 2024 taking place in Naples, Italy, on December ...
PostgreSQL6d
13.3. Explicit Locking
PostgreSQL provides various lock modes to control concurrent access to data in tables. These modes can be used for application-controlled locking in situations where MVCC does not give the desired ...
PostgreSQL6d
F.13. hstore
This module implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value. This can be useful in various scenarios, such as rows with many attributes that are ...
PostgreSQL6d
CREATE ROLE
CREATE ROLE adds a new role to a PostgreSQL database cluster. A role is an entity that can own database objects and have database privileges; a role can be considered a “user”, a “group”, or both ...
PostgreSQL6d
CREATE FUNCTION
CREATE FUNCTION defines a new function. CREATE OR REPLACE FUNCTION will either create a new function, or replace an existing definition. To be able to define a function, the user must have the USAGE ...
PostgreSQL6d
pg_upgrade
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 ...
PostgreSQL6d
43.6. Control Structures
RETURN with an expression terminates the function and returns the value of expression to the caller. This form is used for PL/pgSQL functions that do not return a set. In a function that returns a ...
PostgreSQL6d
37.10. C-Language Functions
The first time a user-defined function in a particular loadable object file is called in a session, the dynamic loader loads that object file into memory so that the function can be called. The CREATE ...
PostgreSQL6d
42.9. Trigger Procedures
A data change trigger is declared as a function with no arguments and a return type of trigger. Note that the function must be declared with no arguments even if it expects to receive some arguments ...