History of Units
  • References/Database/PostgreSQL/Appendixes/DateTime Support

The SQL standard states that "Within the definition of a 'datetime literal', the 'datetime values'

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

The intarray module provides a number of useful functions and operators for manipulating null-free arrays of integers. There is also support for

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

The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the

2025-01-10 15:47:30
PostgreSQL User Account
  • References/Database/PostgreSQL/Server Setup and Operation

As with any server daemon that is accessible to the outside world, it is advisable to run PostgreSQL under a separate user account. This user

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

The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values

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

NameALTER DATABASE -- change a database Synopsis

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

NameCREATE TABLE AS -- define a new table from the results of a query Synopsis

2025-01-10 15:47:30
Internals: Path of a Query
  • References/Database/PostgreSQL/Internals

Here we give a short overview of the stages a query has to pass in order to obtain a result.

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

NameCREATE COLLATION -- define a new collation Synopsis

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