How do I install postgresql and connect via psql?

# Install PostgreSQL ## Option 1: Docker (Recommended for Beginners - Cross-Platform) 1. Install Docker from [docker.com](https://www.docker.com/). 2. Run: ``` docker run --name postgres-learn -e POSTGRES_PASSWORD=postgres -d -p 5432:5432 postgres:18 ``` 3. Connect: `psql -h localhost -p 5432 -U postgres` ## Option 2: Native Install - **Ubuntu/Debian**: `sudo apt update && sudo apt install postgresql-18` - **macOS**: `brew install postgresql@18` - **Windows**: Download installer from [postgresql.org/download/windows](https://www.postgresql.org/download/windows/) 7 Post-install: Start service (e.g., `sudo systemctl start postgresql`), `sudo -u postgres psql`, `CREATE USER myuser WITH SUPERUSER PASSWORD 'mypassword';` Install pgAdmin GUI: [pgadmin.org](https://www.pgadmin.org/) 6

How do I create your first database and tables?

# Basic Setup in psql 1. Connect: `psql -U postgres` 2. Create DB: `CREATE DATABASE learnpg;` 3. Connect to it: `\c learnpg` 4. Create table: ``` CREATE TABLE users ( id SERIAL PRIMARY KEY, name VARCHAR(50), email VARCHAR(100) ); ``` 5. View: `\dt` (lists tables) 64

How do I master crud operations and basic queries?

# Insert, Select, Update, Delete 1. Insert: ``` INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com'); ``` 2. Select: `SELECT * FROM users;` 3. Update: `UPDATE users SET email='new@example.com' WHERE id=1;` 4. Delete: `DELETE FROM users WHERE id=1;` Use `\x` for expanded output, `SELECT COUNT(*) FROM users;` 64

How do I learn joins, aggregates, and complex queries?

# Advanced SQL 1. Add related table: ``` CREATE TABLE orders (id SERIAL PRIMARY KEY, user_id INT REFERENCES users(id)); ``` 2. Insert sample data. 3. Join: `SELECT u.name, o.id FROM users u JOIN orders o ON u.id = o.user_id;` 4. Aggregate: `SELECT COUNT(*), AVG(id) FROM orders GROUP BY user_id;` Explore official tutorial Part II 63

How do I practice with exercises and build a project?

# Hands-On Practice 1. Solve exercises at [pgexercises.com](https://pgexercises.com/) 62 2. Project: Build a blog DB - Tables: posts (id, title, content, user_id), comments (id, post_id, text) - Write queries for top posts by comments, user post count. 3. Read official docs: [postgresql.org/docs/18/](https://www.postgresql.org/docs/18/) 59

Learn PostgreSQL from Scratch in 5 Steps

🧰

Instant Toolkit

2 artifacts

📋
Step-by-Step Guide

1

Install PostgreSQL

Option 1: Docker (Recommended for Beginners - Cross-Platform)

Install Docker from docker.com.
Run:

docker run --name postgres-learn -e POSTGRES_PASSWORD=postgres -d -p 5432:5432 postgres:18

Connect: psql -h localhost -p 5432 -U postgres

Option 2: Native Install

Ubuntu/Debian: sudo apt update && sudo apt install postgresql-18
macOS: brew install postgresql@18
Windows: Download installer from postgresql.org/download/windows

Post-install: Start service (e.g., sudo systemctl start postgresql), sudo -u postgres psql, CREATE USER myuser WITH SUPERUSER PASSWORD 'mypassword';

Install pgAdmin GUI: pgadmin.org

Why this step matters:

-Sets up a working environment to experiment hands-on
-Enables immediate practice without configuration hurdles

30-60 minutes

Docker or package manager, psql, Terminal/Command Prompt, pgAdmin

$0

Definition of Done

•Successfully connected to PostgreSQL using psql
•Listed databases with \l command

Common Mistakes to Avoid

❌ Forgetting to start the PostgreSQL service

→Run 'sudo systemctl start postgresql' or check Docker container status

❌ Using wrong password or port

→Verify POSTGRES_PASSWORD env var and use -h localhost -p 5432

2

Following along, or just reading? 👀

Spin up a personalized “learn PostgreSQL” plan you can save, check off, and return to anytime — unlimited on the free trial.

Start free trial →

3

4

5

🎥
Suggested Videos

Learn PostgreSQL Tutorial - Full Course for Beginners

PostgreSQL Tutorial Full Course 2022

📚
Learning Resources

📖 Online Courses

PostgreSQL Course for Beginners

beginner

freeCodeCamp

📖 Recommended Books

PostgreSQL: Up and Running, 3rd Edition

beginner

by Regina Obe, Leo S. Hsu

🌐 Helpful Websites

PostgreSQL Official Documentation

documentation

Comprehensive manual and tutorial

PG Exercises

exercises

Interactive SQL exercises

🛠️ Useful Tools

psql

CLI

Official command-line client

pgAdmin

GUI

Web-based GUI management tool

Docker Postgres

Container

Containerized PostgreSQL instance

Learn PostgreSQL from Scratch in 5 Steps