Formatting Functions
  • References/Database/PostgreSQL/Functions/Data Type Formatting

The PostgreSQL formatting functions provide a powerful set of tools for converting various data types (date/time, integer, floating point,

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

The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the

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
CREATE TRANSFORM
  • References/Database/PostgreSQL/Commands

NameCREATE TRANSFORM -- define a new transform Synopsis

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
Sequence Functions
  • References/Database/PostgreSQL/Functions and Operators

This section describes functions for operating on sequence objects, also called sequence generators or just sequences. Sequence objects are special

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

NameALTER TRIGGER -- change the definition of a trigger Synopsis

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

The spi module provides several workable examples of using SPI and triggers. While these functions are of some value in their own right, they

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

NameALTER AGGREGATE -- change the definition of an aggregate function Synopsis

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

The catalog pg_cast stores data type conversion paths, both built-in and user-defined. It should be noted that

2025-01-10 15:47:30