Practical introduction to relational databases

Table Overview

Tables are the main source of all data. There are other bits that we're going to talk about, but the data lives in tables; that's where we're going to put them, and that's where we're going to get them out from.

In postgres, each database has multiple schemas. Think of schemas as separate bags that contain database objects: tables, triggers, functions, variables, and so on.

A table will always be in a schema. By default that schema is going to be called public. Depending on the permissions of the database user that is connected, you may or may not be able to access tables in other schemas.

image here about database and schemas and tables

Next up, let's create the product table.