CREATE USER MAPPING
  • References/Database/PostgreSQL/Commands

NameCREATE USER MAPPING -- define a new mapping of a user to a foreign server

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

The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

2025-01-10 15:47:30
Internals//Index Access Method: Basic API Structure for Indexes
  • References/Database/PostgreSQL/Internals/Index Access Method

Each index access method is described by a row in the pg_am

2025-01-10 15:47:30
Internals//Index Access Method: Index Cost Estimation Functions
  • References/Database/PostgreSQL/Internals/Index Access Method

The amcostestimate function is given information describing a possible index scan, including lists of WHERE and ORDER BY clauses that have been

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

The results of two queries can be combined using the set operations union, intersection, and difference. The syntax is

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
Multicolumn Indexes
  • References/Database/PostgreSQL/Indexes

An index can be defined on more than one column of a table. For example, if you have a table of this form:

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
Performance Tips: Populating a Database
  • References/Database/PostgreSQL/Performance Tips

One might need to insert a large amount of data when first populating a database. This section contains some suggestions on how to make this process as efficient as possible

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