Tables, rows, and your first SELECT

Data in tables

A relational database stores data in tables. A table is a grid: each row is one thing (one book, one customer) and each column is one attribute of that thing (a title, a price). Unlike a spreadsheet, every value in a column has the same type, and rows have no inherent order — you ask for the order you want.

Throughout this course you'll work a single small database: an online bookshop. Its core table is books. To read data you write a query with SELECT. The simplest one asks for every column (*) of every row:

SELECT * FROM books;

Run it below against real Postgres and look at the columns you get back. Open the schema panel any time to see every table.