CREATE ROLE
  • References/Database/PostgreSQL/Commands

NameCREATE ROLE -- define a new database role Synopsis

2025-01-10 15:47:30
DROP TEXT SEARCH TEMPLATE
  • References/Database/PostgreSQL/Commands

NameDROP TEXT SEARCH TEMPLATE -- remove a text search template Synopsis

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

NameCREATE RULE -- define a new rewrite rule Synopsis

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

The catalog pg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the

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

sepgsql is a loadable module that supports label-based mandatory access control (MAC) based on SELinux security

2025-01-10 15:47:30
SELECT INTO
  • References/Database/PostgreSQL/Commands

NameSELECT INTO -- define a new table from the results of a query Synopsis

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

A table in a relational database is much like a table on paper: It consists of rows and columns. The number and order of the columns is fixed, and each column has a name. The

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

Namepg_archivecleanup -- clean up PostgreSQL WAL archive files

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

NameCREATE TRIGGER -- define a new trigger Synopsis

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

In order to create a database, the PostgreSQL server must be up and running (see

2025-01-10 15:47:30