Use system catalogs and system views in PostgreSQL

Intermediate
Database Administrator
Database for PostgreSQL

System information is known as metadata and is stored in system catalogs in Azure Database for PostgreSQL. In addition to directly accessing system catalogs, you can access system views.

Learning objectives

After completing this module, you'll be able to:

  • Describe system catalogs and system views in Azure Database for PostgreSQL.
  • Investigate metadata in Azure Database for PostgreSQL.

Prerequisites

  • Demonstrate an understanding of relational databases.
  • Demonstrate an understanding of basic SQL.