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

The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server

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

Namepg_dump -- extract a PostgreSQL database into a script file or other archive file

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

NameCREATE DATABASE -- create a new database Synopsis

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

NameSET ROLE -- set the current user identifier of the current session Synopsis

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

Namedropuser -- remove a PostgreSQL user account

2025-01-10 15:47:30
8.
  • References/Database/PostgreSQL/Tutorial/The SQL Language

You can update existing rows using the UPDATE command. Suppose you discover the temperature readings are all off by 2 degrees after November 28

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

So far we have explained how to add data to tables and how to change data. What remains is to discuss how to remove data that is no longer needed. Just as adding data is only

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

NameLOCK -- lock a table Synopsis

2025-01-10 15:47:30
Full Text Search: Additional Features
  • References/Database/PostgreSQL/Full Text Search

This section describes additional functions and operators that are useful in connection with text search. 12

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

NameSELECT, TABLE, WITH -- retrieve rows from a table or view Synopsis

2025-01-10 15:47:30