Get startedGet started for free

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.

This exercise is part of the course

Applying SQL to Real-World Problems

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.



SELECT table_name, 
       STRING_AGG(___, ', ') AS ___
FROM information_schema.columns
WHERE table_schema = 'public'
GROUP BY ___;
Edit and Run Code