The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

NameDROP USER -- remove a database role Synopsis

NameDEALLOCATE -- deallocate a prepared statement Synopsis

Enumerated (enum) types are data types that comprise a static, ordered set of values. They are equivalent to the enum types supported in a number

Although indexes in PostgreSQL do not need maintenance or tuning, it is still important to check which indexes are actually used by the real-life

On most Unix platforms, PostgreSQL modifies its command title as reported by ps, so that individual server processes

Full Text Searching (or just text search) provides the capability to identify natural-language documents that satisfy a

Recall from Chapter 19 that the PostgreSQL server provides a large number of run-time configuration variables. You can set database-specific

Each table has a primary heap disk file where most of the data is stored. If the table has any columns with potentially-wide values, there also might be a

This section describes functions and operators for examining and manipulating values of type bytea.