pg_amcheck

all

Check for corruption in one or more PostgreSQL databases.

Options (5)

-a, --allboolean

Check all databases

Example: pg_amcheck {{[-a|--all]}}

-d, --databaseboolean

Check databases matching the specified pattern

Example: pg_amcheck {{[-d|--database]}} {{pattern}}

-t, --tableboolean

Check specific tables within a database

Example: pg_amcheck {{[-t|--table]}} {{pattern}} {{dbname}}

-s, --schemaboolean

Check specific schemas within a database

Example: pg_amcheck {{[-s|--schema]}} {{pattern}} {{dbname}}

--helpboolean

Display help

Example: pg_amcheck {{[-?|--help]}}

Check a specific database

pg_amcheck dbname

Check all databases

pg_amcheck [-a|--all]

Check databases matching the specified pattern

pg_amcheck [-d|--database] pattern

Check specific tables within a database

pg_amcheck [-t|--table] pattern dbname

Check specific schemas within a database

pg_amcheck [-s|--schema] pattern dbname

Display help

pg_amcheck [-?|--help]