ALTER TABLESPACE
  • References/Database/PostgreSQL/Commands

NameALTER TABLESPACE -- change the definition of a tablespace Synopsis

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

Namecreateuser -- define a new PostgreSQL user account

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

CREATE DATABASE actually works by copying an existing database. By default, it copies the standard system database named template1

2025-01-10 15:47:30
Standby Server Settings
  • References/Database/PostgreSQL/Recovery Configuration

standby_mode (boolean) Specifies whether to start the

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

The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search

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

The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows

2025-01-10 15:47:30
Index-Only Scans
  • References/Database/PostgreSQL/Indexes

All indexes in PostgreSQL are secondary indexes, meaning that each index is stored separately from the table's main

2025-01-10 15:47:30
Date/Time Input Interpretation
  • References/Database/PostgreSQL/Appendixes/DateTime Support

The date/time type inputs are all decoded using the following procedure. Break the input

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

SP-GiST offers an interface with a high level of abstraction, requiring the access method developer to implement only methods specific to

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

The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but

2025-01-10 15:47:30