NameSELECT, TABLE, WITH -- retrieve rows from a table or view Synopsis

NameDO -- execute an anonymous code block Synopsis

The behavior of a custom text search configuration can easily become confusing. The functions described in this section are useful for testing text search objects. You can

NameDISCARD -- discard session state Synopsis

A window function performs a calculation across a set of table rows that are somehow related to the current row. This is comparable to the type of

NameSAVEPOINT -- define a new savepoint within the current transaction Synopsis

Inheritance is a concept from object-oriented databases. It opens up interesting new possibilities of database design. Let's create two tables:

PostgreSQL has many features not touched upon in this tutorial introduction, which has been oriented toward newer users of

Namepgbench -- run a benchmark test on PostgreSQL

In addition to the system catalogs, PostgreSQL provides a number of built-in views. Some system views provide convenient access to some commonly