Retrieving Data from Tables

Learn about retrieving data from tables in PostgreSQL.

The SELECT query

The basic unit of data storage in PostgreSQL is tables. A table consists of a collection of rows, and each row has a set of columns containing that row’s data. To get data out of a table, we use the SELECT statement.

The most basic form of the SELECT statement looks like this:

Get hands-on with 1400+ tech skills courses.