The catalog pg_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the
NameUPDATE -- update rows of a table Synopsis
After a query has produced an output table (after the select list has been processed) it can optionally be sorted. If sorting is not chosen, the rows will be returned in an
The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before
The amcostestimate function is given information describing a possible index scan, including lists of WHERE and ORDER BY clauses that have been
The results of two queries can be combined using the set operations union, intersection, and difference. The syntax is
The current limitations of PostgreSQL's text search features are: The
Shared Disk Failover Shared disk failover avoids synchronization overhead by having only one copy of the database. It uses a single
WAL is automatically enabled; no action is required from the administrator except ensuring that the disk-space requirements for the
The view pg_roles provides access to information about database roles. This is simply a publicly readable view of
Page 32 of 60