System Columns
  • References/Database/PostgreSQL/Data Definition

Every table has several system columns that are implicitly defined by the system. Therefore, these names cannot be used as names of user-defined columns

2025-01-10 15:47:30
Full Text Search: GIN and GiST Index Types
  • References/Database/PostgreSQL/Full Text Search

There are two kinds of indexes that can be used to speed up full text searches. Note that indexes are not mandatory for full text searching, but in cases where a column is

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

Because roles can own database objects and can hold privileges to access other objects, dropping a role is often not just a matter of a quick

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

NameCREATE OPERATOR -- define a new operator Synopsis

2025-01-10 15:47:30
Destroying a Database
  • References/Database/PostgreSQL/Managing Databases

Databases are destroyed with the command DROP DATABASE:

2025-01-10 15:47:30
Geometric Types
  • References/Database/PostgreSQL/Data Types

Geometric data types represent two-dimensional spatial objects. Table 8-20 shows the geometric types available in PostgreSQL.

2025-01-10 15:47:30
Internals: Parser Stage
  • References/Database/PostgreSQL/Internals

The parser stage consists of two parts: The parser defined in gram

2025-01-10 15:47:30
Internals//SP-GiST Indexes: Implementation
  • References/Database/PostgreSQL/Internals/SP-GiST Indexes

This section covers implementation details and other tricks that are useful for implementers of SP-GiST operator classes to know.

2025-01-10 15:47:30
ROLLBACK TO SAVEPOINT
  • References/Database/PostgreSQL/Commands

NameROLLBACK TO SAVEPOINT -- roll back to a savepoint Synopsis

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

bloom provides an index access method based on Bloom filters

2025-01-10 15:47:30