Catalogs: pg_user
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_user provides access to information about database users. This is simply a publicly readable view of

2025-01-10 15:47:30
2.
  • References/Database/PostgreSQL/Tutorial/Advanced Features

Refer back to the queries in Section 2.6. Suppose the combined listing

2025-01-10 15:47:30
Role Membership
  • References/Database/PostgreSQL/Database Roles

It is frequently convenient to group users together to ease management of privileges: that way, privileges can be granted to, or revoked from, a group as a whole. In

2025-01-10 15:47:30
Internals//Physical Storage: Free Space Map
  • References/Database/PostgreSQL/Internals/Physical Storage

Each heap and index relation, except for hash indexes, has a Free Space Map (FSM) to keep track of available space in the relation. It's stored alongside the main relation

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

NameALTER LANGUAGE -- change the definition of a procedural language Synopsis

2025-01-10 15:47:30
Type Conversion: UNION, CASE, and Related Constructs
  • References/Database/PostgreSQL/Type Conversion

SQL UNION constructs must match up possibly dissimilar types to become a single result set. The resolution algorithm is applied separately to each

2025-01-10 15:47:30
XML Type
  • References/Database/PostgreSQL/Data Types

The xml data type can be used to store XML data. Its advantage over storing XML data in a text field is that it checks the

2025-01-10 15:47:30
Internals//GIN Indexes: GIN Tips and Tricks
  • References/Database/PostgreSQL/Internals/GIN Indexes

Create vs. insert Insertion into a GIN index can be slow due to the likelihood of many keys

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

This module implements a data type seg for representing line segments, or floating point intervals. seg can represent uncertainty

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

The catalog pg_extension stores information about the installed extensions. See Section 36.15 for details about extensions.

2025-01-10 15:47:30