DROP TABLE
  • References/Database/PostgreSQL/Commands

NameDROP TABLE -- remove a table Synopsis

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

dict_int is an example of an add-on dictionary template for full-text search. The motivation for this example dictionary is to control the indexing

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

NameCREATE OPERATOR CLASS -- define a new operator class Synopsis

2025-01-10 15:47:30
Value Expressions
  • References/Database/PostgreSQL/Syntax

Value expressions are used in a variety of contexts, such as in the target list of the SELECT command, as new column values in

2025-01-10 15:47:30
Internals//GIN Indexes: Built-in Operator Classes
  • References/Database/PostgreSQL/Internals/GIN Indexes

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

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

61.4.1. GiST buffering build Building large GiST indexes by simply inserting all the tuples tends to be slow, because if the index

2025-01-10 15:47:30
Comparisons
  • References/Database/PostgreSQL/Functions and Operators

The usual comparison operators are available, as shown in Table 9-1. Table 9-1. Comparison Operators

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

Database roles are conceptually completely separate from operating system users. In practice it might be convenient to maintain a correspondence, but this is not required.

2025-01-10 15:47:30
Explicit Locking
  • References/Database/PostgreSQL/Concurrency Control

PostgreSQL provides various lock modes to control concurrent access to data in tables. These modes can be used for application-controlled locking

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

NameCREATE CAST -- define a new cast Synopsis

2025-01-10 15:47:30