Getting information about your database
As we saw in the video, PostgreSQL has a system database called INFORMATION_SCHEMA that allows us to extract information about objects, including tables, in our database.
In this exercise we will look at how to query the tables table of the INFORMATION_SCHEMA database to discover information about tables in the DVD Rentals database including the name, type, schema, and catalog of all tables and views and then how to use the results to get additional information about columns in our tables.
Deze oefening maakt deel uit van de cursus
Functions for Manipulating Data in PostgreSQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Select all columns from the TABLES system database
SELECT *
FROM ___.___
-- Filter by schema
WHERE table_schema = ___;