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
btree_gin
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

btree_gin provides sample GIN operator classes that implement B-tree equivalent behavior for the data types int2,

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

The pageinspect module provides functions that allow you to inspect the contents of database pages at a low level, which is useful for debugging

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

The isn module provides data types for the following international product numbering standards: EAN13, UPC, ISBN (books), ISMN (music), and ISSN

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
Acronyms
  • References/Database/PostgreSQL/Appendixes/Appendixes

This is a list of acronyms commonly used in the PostgreSQL documentation and in discussions about PostgreSQL

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

The uuid-ossp module provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms. There are

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

Table B-1 shows the tokens that are recognized as names of months. Table B-1. Month Names

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
pgstattuple
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The pgstattuple module provides various functions to obtain tuple-level statistics. F

2025-01-10 15:47:30