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

NameCREATE SCHEMA -- define a new schema Synopsis

The isn module provides data types for the following international product numbering standards: EAN13, UPC, ISBN (books), ISMN (music), and ISSN

The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in

NameCREATE VIEW -- define a new view Synopsis

It is very difficult to enforce business rules regarding data integrity using Read Committed transactions because the view of the data is shifting with each statement, and

Each unlogged table, and each index on an unlogged table, has an initialization fork. The initialization fork is an empty table or index of the appropriate type. When an unlogged

The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of

The core PostgreSQL distribution includes the GiST operator classes shown in Table 61-1. (Some of the optional

The bytea data type allows storage of binary strings; see Table 8-6. Table 8-6. Binary