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
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
Catalogs: pg_foreign_table
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_foreign_table contains auxiliary information about foreign tables. A foreign table is primarily represented by a

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

Nameclusterdb -- cluster a PostgreSQL database

2025-01-10 15:47:30
Server Configuration: Replication
  • References/Database/PostgreSQL/Server Configuration

These settings control the behavior of the built-in streaming replication feature (see Section 26.2.5). Servers will be either a Master or a Standby

2025-01-10 15:47:30