REVOKE
  • References/Database/PostgreSQL/Commands

NameREVOKE -- remove access privileges Synopsis

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

NameCOMMENT -- define or change the comment of an object Synopsis

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

WITH provides a way to write auxiliary statements for use in a larger query. These statements, which are often referred to as Common Table Expressions

2025-01-10 15:47:30
Performance Tips: EXPLAIN
  • References/Database/PostgreSQL/Performance Tips

PostgreSQL devises a query plan for each query it receives. Choosing the right plan to match the query structure and

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

NameCREATE SERVER -- define a new foreign server Synopsis

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

NameALTER FOREIGN TABLE -- change the definition of a foreign table Synopsis

2025-01-10 15:47:30
Server Configuration: Write Ahead Log
  • References/Database/PostgreSQL/Server Configuration

For additional information on tuning these settings, see Section 30.4.

2025-01-10 15:47:30
Performance Tips: Statistics Used by the Planner
  • References/Database/PostgreSQL/Performance Tips

As we saw in the previous section, the query planner needs to estimate the number of rows retrieved by a query in order to make good choices of query plans. This section provides

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

NameGRANT -- define access privileges Synopsis

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

The pg_lsn data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation

2025-01-10 15:47:30