pg_visibility
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The pg_visibility module provides a means for examining the visibility map (VM) and page-level visibility information. It also provides functions

2025-01-10 15:47:30
System Columns
  • References/Database/PostgreSQL/Data Definition

Every table has several system columns that are implicitly defined by the system. Therefore, these names cannot be used as names of user-defined columns

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

The pg_prepared_statements view displays all the prepared statements that are available in the current session. See

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

Reliability is an important property of any serious database system, and PostgreSQL does everything possible to guarantee reliable operation

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

The intarray module provides a number of useful functions and operators for manipulating null-free arrays of integers. There is also support for

2025-01-10 15:47:30
SQL Key Words
  • References/Database/PostgreSQL/Appendixes/Appendixes

Table C-1 lists all tokens that are key words in the SQL standard and in PostgreSQL 9.6.0. Background information can be found in Section 4

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

The catalog pg_operator stores information about operators. See CREATE

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

NameDROP TABLE -- remove a table Synopsis

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

auth_delay causes the server to pause briefly before reporting authentication failure, to make brute-force attacks on database passwords more

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

NameCREATE TABLE AS -- define a new table from the results of a query Synopsis

2025-01-10 15:47:30