SQL Dump
  • References/Database/PostgreSQL/Backup and Restore

The idea behind this dump method is to generate a file with SQL commands that, when fed back to the server, will recreate the database in the same state as it was at the time

2025-01-10 15:47:30
REFRESH MATERIALIZED VIEW
  • References/Database/PostgreSQL/Commands

NameREFRESH MATERIALIZED VIEW -- replace the contents of a materialized view Synopsis

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

NameDROP COLLATION -- remove a collation Synopsis

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

NameCOMMIT PREPARED -- commit a transaction that was earlier prepared for two-phase commit

2025-01-10 15:47:30
CREATE TEXT SEARCH DICTIONARY
  • References/Database/PostgreSQL/Commands

NameCREATE TEXT SEARCH DICTIONARY -- define a new text search dictionary Synopsis

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

The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration

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

NameGRANT -- define access privileges Synopsis

2025-01-10 15:47:30
CREATE TEXT SEARCH PARSER
  • References/Database/PostgreSQL/Commands

NameCREATE TEXT SEARCH PARSER -- define a new text search parser Synopsis

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

The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning

2025-01-10 15:47:30
CREATE FOREIGN DATA WRAPPER
  • References/Database/PostgreSQL/Commands

NameCREATE FOREIGN DATA WRAPPER -- define a new foreign-data wrapper Synopsis

2025-01-10 15:47:30