PGDay Israel 2024 takes place in Tel Aviv, Israel, on October 20. Our Call for Papers is now open. We are accepting proposals for talks in English and Hebrew. Each session will last 40 minutes, and ...

PGConf.EU 2024 will take place in Athens from October 22-25, gathering attendees from around the world and across industries. Developers, DBAs, product managers, company CTOs, and CEOs will come ...

When logging_collector is enabled, this parameter sets the file names of the created log files. The value is treated as a strftime pattern, so %-escapes can be used to specify time-varying file names.

ALTER SUBSCRIPTION can change most of the subscription properties that can be specified in CREATE SUBSCRIPTION. When refreshing a publication we remove the relations that are no longer part of the ...

DROP SCHEMA removes schemas from the database. A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained objects) even if they do not ...

CREATE TRIGGER creates a new trigger. The trigger will be associated with the specified table, view, or foreign table and will execute the specified function function_name when certain operations are ...

dblink_connect — opens a persistent connection to a remote database dblink_connect_u — opens a persistent connection to a remote database, insecurely dblink_disconnect — closes a persistent connection ...

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 part covers topics that are of interest to a PostgreSQL database administrator. This includes installation of the software, set up and configuration of the server, management of users and ...

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 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 ...

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 ...