CREATE SCHEMA
  • References/Database/PostgreSQL/Commands

NameCREATE SCHEMA -- define a new schema Synopsis

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

NameCREATE EVENT TRIGGER -- define a new event trigger Synopsis

2025-01-10 15:47:30
ORDER BY
  • References/Database/PostgreSQL/Queries

After a query has produced an output table (after the select list has been processed) it can optionally be sorted. If sorting is not chosen, the rows will be returned in an

2025-01-10 15:47:30
DROP TYPE
  • References/Database/PostgreSQL/Commands

NameDROP TYPE -- remove a data type Synopsis

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

The citext module provides a case-insensitive character string type, citext. Essentially, it internally calls

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

NameCREATE INDEX -- define a new index Synopsis

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

The catalog pg_proc stores information about functions (or procedures). See

2025-01-10 15:47:30
Text Search Types
  • References/Database/PostgreSQL/Data Types

PostgreSQL provides two data types that are designed to support full text search, which is the activity of searching through a collection of

2025-01-10 15:47:30
Data Consistency Checks at the Application Level
  • References/Database/PostgreSQL/Concurrency Control

It is very difficult to enforce business rules regarding data integrity using Read Committed transactions because the view of the data is shifting with each statement, and

2025-01-10 15:47:30
DROP SEQUENCE
  • References/Database/PostgreSQL/Commands

NameDROP SEQUENCE -- remove a sequence Synopsis

2025-01-10 15:47:30