PostgreSQL

PostgreSQL SELECT

Retrieve columns and rows from a PostgreSQL table.

Select columns

Use SELECT with FROM to read data. List only the columns needed.

SELECT name, model, year
FROM products;

Use SELECT * to return every column, although explicit columns are usually clearer for applications.