Knowledge check

Choose the best response for each of the questions below. Then select Check your answers.

Check your knowledge

Which schema stores metadata in PostgreSQL?

pg_schema

pg_catalog

pg_metadata

Which system table contains lock information for each database?

pg_database.

pg_stat_database.

pg_database_lock.

Which view can you use to get a list of all views in your database, which you can filter to display system views?

pg_views.

pg_catalog.

pg_system_view.

You must answer all questions before checking your work.