PostgreSQL Administration

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

    This article describes two methods for listing tables in a database in PostgreSQL.

  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. PostgreSQL Reset Password

    This article describes the detailed steps to reset the password of the PostgreSQL superuser.