Finding the table type
Throughout this course, you have been working with data about Olympic athletes, countries' climate, and countries' demographics. You may have wondered if these data sources were actually tables or instead views. Knowing this information could help you decide how to structure your queries and understand why a query may be slow (e.g. it uses a view).
In this chapter, you will work with air quality data. One of the main data sources is annual_aqi. Determine if it really is a table.
Bu egzersiz
Improving Query Performance in PostgreSQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT DISTINCT ___
FROM information_schema.___
WHERE table_catalog = 'olympics_aqi';