Indexes and Collations
  • References/Database/PostgreSQL/Indexes

An index can support only one collation per index column. If multiple collations are of interest, multiple indexes may be needed. Consider these

2025-01-10 15:47:30
Catalogs: pg_cursors
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways:

2025-01-10 15:47:30
Partial Indexes
  • References/Database/PostgreSQL/Indexes

A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate

2025-01-10 15:47:30
VALUES
  • References/Database/PostgreSQL/Commands

NameVALUES -- compute a set of rows Synopsis

2025-01-10 15:47:30
DROP FUNCTION
  • References/Database/PostgreSQL/Commands

NameDROP FUNCTION -- remove a function Synopsis

2025-01-10 15:47:30
CREATE AGGREGATE
  • References/Database/PostgreSQL/Commands

NameCREATE AGGREGATE -- define a new aggregate function Synopsis

2025-01-10 15:47:30
cube
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

This module implements a data type cube for representing multidimensional cubes. F

2025-01-10 15:47:30
Catalogs: pg_file_settings
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each

2025-01-10 15:47:30
Default Roles
  • References/Database/PostgreSQL/Database Roles

PostgreSQL provides a set of default roles which provide access to certain, commonly needed, privileged capabilities and information. Administrators

2025-01-10 15:47:30
ALTER FOREIGN TABLE
  • References/Database/PostgreSQL/Commands

NameALTER FOREIGN TABLE -- change the definition of a foreign table Synopsis

2025-01-10 15:47:30