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

The passwordcheck module checks users' passwords whenever they are set with CREATE

The GEQO module approaches the query optimization problem as though it were the well-known traveling salesman problem (

The pg_freespacemap module provides a means for examining the free space map (FSM). It provides a function called pg_freespace

dict_xsyn (Extended Synonym Dictionary) is an example of an add-on dictionary template for full-text search. This dictionary type replaces words

It is a good idea to save the database server's log output somewhere, rather than just discarding it via /dev/null. The log output is invaluable

Asynchronous commit is an option that allows transactions to complete more quickly, at the cost that the most recent transactions may be lost if the

NameDROP DOMAIN -- remove a domain Synopsis

The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 62-1.

Index access methods must handle concurrent updates of the index by multiple processes. The core PostgreSQL system obtains