Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, released an updated version ...

The CERN PGDay builds on the experience of past PostgreSQL events at CERN and a newly establish collaboration with SwissPUG.

This release contains a few fixes from 17.1. For information about new features in major release 17, see Section E.3.

This function opens a new database connection using the parameters taken from two NULL-terminated arrays. The first, keywords, is defined as an array of strings, each one being a key word. The second, ...

pg_restore — restore a PostgreSQL database from an archive file created by pg_dump Restore only the data, not the schema (data definitions). Table data, large objects, and sequence values are restored ...

JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 7159. Such data can also be stored as text, but the JSON data types have the advantage of enforcing that ...

Specifies the TCP/IP address(es) on which the server is to listen for connections from client applications. The value takes the form of a comma-separated list of host names and/or numeric IP addresses ...

Commercial support is available from many different companies providing professional services to the PostgreSQL community.

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

To provide native support for JSON data types within the SQL environment, PostgreSQL implements the SQL/JSON data model. This model comprises sequences of items. Each item can hold SQL scalar values, ...

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

libpq pipeline mode allows applications to send a query without having to read the result of the previously sent query. Taking advantage of the pipeline mode, a client will wait less for the server, ...