DatabaseLesson 8Free preview

PostgreSQL Fetch Data

This lesson is part of PostgreSQL · All levels

Summary

Fetch Data discusses how to read data from a table using the SELECT command. You can choose the entire column with an asterisk or just the specific column that you need. Combining with WHERE, ORDER BY, and LIMIT makes the results more relevant and easy to read.

Key points

SELECT * displays the entire column; it is best to specify the column that is actually used.
Columns can be selected partially and are alias with U.S.
Combine with WHERE, ORDER BY, and LIMIT to get more targeted results.
Good practice: select the appropriate columns to make the query lighter and more stable.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.