What columns are in your database?
Just like pg_catalog.pg_tables can be incredibly helpful for listing all the tables in your database, information_schema.columns can be used to list the columns of these tables. In this exercise, you will combine these system tables to get a list of all of the columns for all your tables (in the 'public' schema).
Note: These system tables are specific to PostgreSQL but similar tables exist for other databases (see slides).
Bu egzersiz
Applying SQL to Real-World Problems
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Select all columns from the information_schema.columns table
___
___;