A VIEW of all your columns
In this exercise you will create a new tool for finding the tables and columns you need. Using the system table information_schema.columns you will concatenate the list of each table's columns into a single entry.
Once you've done this you will make this query easily reusable by creating a new VIEW for it called table_columns.
Diese Übung ist Teil des Kurses
Applying SQL to Real-World Problems
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
SELECT table_name,
STRING_AGG(___, ', ') AS ___
FROM information_schema.columns
WHERE table_schema = 'public'
GROUP BY ___;