CREATE OPERATOR CLASS
  • References/Database/PostgreSQL/Commands

NameCREATE OPERATOR CLASS -- define a new operator class Synopsis

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 TABLE
  • References/Database/PostgreSQL/Commands

NameCREATE TABLE -- define a new table Synopsis

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

unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, which means its output

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

The view pg_config describes the compile-time configuration parameters of the currently installed version of PostgreSQL

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

NameALTER OPERATOR CLASS -- change the definition of an operator class Synopsis

2025-01-10 15:47:30
Inheritance
  • References/Database/PostgreSQL/Data Definition

PostgreSQL implements table inheritance, which can be a useful tool for database designers. (SQL:1999 and later define a type inheritance feature

2025-01-10 15:47:30
Internals: How Connections are Established
  • References/Database/PostgreSQL/Internals

PostgreSQL is implemented using a simple "process per user" client/server model. In this model there is one

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

Currently PostgreSQL provides one built in trigger function, suppress_redundant_updates_trigger, which will prevent

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

The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection

2025-01-10 15:47:30