The catalog pg_pltemplate stores "template" information for procedural languages. A template for a language allows

NamePREPARE TRANSACTION -- prepare the current transaction for two-phase commit

Data types are a way to limit the kind of data that can be stored in a table. For many applications, however, the constraint they provide is too coarse. For example, a column

NameCREATE ROLE -- define a new database role Synopsis

So far we have explained how to add data to tables and how to change data. What remains is to discuss how to remove data that is no longer needed. Just as adding data is only

btree_gist provides GiST index operator classes that implement B-tree equivalent behavior for the data types int2,

There are several WAL-related configuration parameters that affect database performance. This section explains their use. Consult Chapter

The PostgreSQL source distribution includes several examples of index methods implemented using GiST. The

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

This style guide is offered in the hope of maintaining a consistent, user-friendly style throughout all the messages generated by PostgreSQL