Menu

PostgreSQL Administration

Manage PostgreSQL users, privileges, passwords, backups, restores, psql commands, and query plans.

This chapter introduces the knowledge related to managing databases in PostgreSQL, including user permissions, reseting passwords, database backup and restore, psql commands and explain.

  1. PostgreSQL psql Commands

    This article introduces the commonly used commands in the psql tool provided by PostgreSQL.

  2. PostgreSQL Show Databases

    This article describes two methods for listing databases in PostgreSQL.

  3. PostgreSQL Objects Size

    This article describes how to view the size of databases, tables, indexes, and tablespaces in PostgreSQL.

  4. PostgreSQL Copy Databases

    This article describes several ways to copy databases in PostgreSQL.

  5. PostgreSQL Show Tables

    List PostgreSQL tables from psql or SQL, include all schemas, query pg_catalog.pg_tables, and troubleshoot missing tables.

  6. PostgreSQL Describe Tables

    This article describes two ways to view the definition or structure of a table in PostgreSQL.

  7. PostgreSQL Copy Tables

    This article describes several ways to copy tables in PostgreSQL

  8. PostgreSQL Export and Import

    This article describes how to back up a PostgreSQL database using pg_dump and pg_dumpall and how to restore PostgreSQL database using pg_restore.

  9. PostgreSQL EXPLAIN

    This article describes the usage of the EXPLAIN statement in PostgreSQL.

  10. Reset Password

    Reset a PostgreSQL role password safely with psql, including local peer-authenticated access and managed database recovery paths.