Creating Tables in Postgres

Now that we have a basic database design, the next step is to write SQL to create our first table.

In this lesson, we will create a table called cities with four columns:

• name
• country
• population
• area

We will run all SQL inside Supabase using its built-in SQL Editor.

Where Do We Write SQL in Supabase?

In Supabase:

1. Open your Supabase project 2. Go to SQL Editor 3. Click New Query 4. Write your SQL and press Run

Behind the scenes, this is what is happening:

• Supabase (the dashboard) acts like a client
• You write SQL in the SQL Editor
• Supabase sends that SQL to the PostgreSQL database
• PostgreSQL runs it and sends back the result

So yes — you are working with a real PostgreSQL database.

The SQL to Create the cities Table

Now let’s write the SQL.

create table cities (
  name varchar(50),
  country varchar(50),
  population integer,
  area integer
);

What this SQL means

• create table cities → create a table named cities
• Inside ( ... ) we define columns
• Each column has:
• a column name
• a data type