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

The view pg_rules provides access to useful information about query rewrite rules. Table

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

NameREVOKE -- remove access privileges Synopsis

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

The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view

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
COMMENT
  • References/Database/PostgreSQL/Commands

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

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

PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base

2025-01-10 15:47:30
pg_restore
  • References/Database/PostgreSQL/Applications

Namepg_restore -- restore a PostgreSQL database from an archive file created by pg_dump

2025-01-10 15:47:30
Range Functions and Operators
  • References/Database/PostgreSQL/Functions/Range

See Section 8.17 for an overview of range types. Table 9-49 shows

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

PostgreSQL implements portions of the SQL/MED specification, allowing you to access data that resides outside PostgreSQL using regular SQL

2025-01-10 15:47:30
Inserting Data
  • References/Database/PostgreSQL/Data Manipulation

When a table is created, it contains no data. The first thing to do before a database can be of much use is to insert data. Data is conceptually inserted one row at a time

2025-01-10 15:47:30