PostgreSQL Tutorials: Learn PostgreSQL Step by Step

New to PostgreSQL? Start here

Read these in order. Each one builds on the one before it.

1. How to Download and Install PostgreSQL on WindowsInstall PostgreSQL and pgAdmin on Windows.
2. How to Connect to a PostgreSQL Database (psql, pgAdmin, Linux, Python)Connect with psql, pgAdmin or code.
3. How to Create Database in PostgreSQLCreate your first database.
4. How to create a table in PostgreSQLCreate a table with the right data types.
5. PostgreSQL SELECTRead and filter your data.
6. PostgreSQL JoinsCombine data from related tables.

The basics6

What it is, what it's good for, and the questions people ask before they commit to it.

• PostgreSQL Architecture
• PostgreSQL Certification
• PostgreSQL System Requirements
• What is PostgreSQL Good For
• What Is Postgresql Used For
• Why Use PostgreSQL

Install, connect and tools8

Install it, connect to it, and get your tools working.

• How To Check PostgreSQL Version
• How to Restart PostgreSQL (Linux, Windows, Mac)
• How to Uninstall PostgreSQL (Linux, Mac,Windows)
• PostgreSQL installation on Linux step by step
• PostgreSQL Latest Version
• Postgresql listen_addresses
• How to Connect to a PostgreSQL Database (psql, pgAdmin, Linux, Python)
• How to Download and Install PostgreSQL on Windows

Databases, tables and columns18

Create and change databases, tables, columns, keys, indexes and views.

• Drop Database PSQL
• How To Create An Index In PostgreSQL
• How to Create View in PostgreSQL
• How to Drop All Tables in PostgreSQL
• How to find primary column name in Postgresql
• How to Rename Column in PostgreSQL
• PostgreSQL ADD COLUMN
• PostgreSQL Add Foreign Key If Not Exists
• PostgreSQL add primary key
• PostgreSQL ALTER TABLE
• PostgreSQL CASE Multiple Columns
• PostgreSQL DROP COLUMN
• PostgreSQL DROP TABLE
• PostgreSQL List Databases
• PostgreSQL Schema
• PostgreSQL Unique Constraint
• How to create a table in PostgreSQL
• How to Create Database in PostgreSQL

Data types6

Pick the right data type for every column.

• How To Set Auto Increment In PostgreSQL
• PostgreSQL Add Primary Key Autoincrement
• PostgreSQL change column data type
• PostgreSQL Data Types
• PostgreSQL Order By Enum
• PostgreSQL Order By JSON Field

SELECT queries, filtering and grouping10

Read data with SELECT, filter it, sort it and summarize it.

• Group By in PostgreSQL
• How to Escape Single Quote in PostgreSQL
• How to Use Postgresql Having Clause
• PostgreSQL Average
• Postgresql generate_series Examples
• PostgreSQL Subquery with Examples
• PostgreSQL Sum
• PostgreSQL WHERE Clause
• Row_number in PostgreSQL
• PostgreSQL SELECT

Joins2

Combine rows from two or more tables.

• PostgreSQL multiple joins
• PostgreSQL Joins

Insert, update and delete5

Add, change and remove rows safely.

• How to Delete Row in PostgreSQL
• PostgreSQL Insert Into Table Select * From Another Table
• PostgreSQL INSERT Multiple Rows
• PostgreSQL Update Join
• PostgreSQL UPDATE Query: Multiple Columns, FROM, LIMIT and RETURNING

Strings, numbers and conversions9

Work with text and numbers, and convert between types.

• Format Number in PostgreSQL
• How To Concat In PostgreSQL
• How to remove special characters in PostgreSQL
• How to use ilike in PostgreSQL
• PostgreSQL Cast Int
• PostgreSQL group_concat Example
• PostgreSQL LENGTH(): Length of a String, char_length and octet_length
• PostgreSQL Like Operator
• PostgreSQL To_Number

Dates and times13

Format, compare and calculate dates and times.

• How to find date difference in PostgreSQL
• Postgres date range
• Postgres Timestamp Comparison
• PostgreSQL Cast Timestamp To Date
• PostgreSQL current_timestamp
• PostgreSQL Date Add
• PostgreSQL date between two dates
• PostgreSQL Date Part Hour
• PostgreSQL date string to timestamp
• PostgreSQL date to string
• PostgreSQL ORDER BY: DESC LIMIT 1, Dates, NULLs and Custom Order
• PostgreSQL To_Char Date Format
• PostgreSQL TO_TIMESTAMP

Functions7

Built-in functions and the ones you write yourself.

• How to return a table in PostgreSQL function
• Postgres Min Function
• PostgreSQL DATE Functions Examples
• PostgreSQL date_trunc function
• PostgreSQL NOW() Function: Transaction Time, Time Zones and CURRENT_TIMESTAMP
• PostgreSQL RANK Function
• Postgresql REGEXP_REPLACE Function

Stored procedures, variables and control flow5

Stored procedures, variables, IF/CASE logic, loops, error handling and transactions.

• Create a stored procedure in PostgreSQL
• PL/pgSQL Block Structure in PostgreSQL
• PostgreSQL FOR Loop (PL/pgSQL): FOR, FOREACH, LOOP, EXIT and CONTINUE
• PostgreSQL If Else Statement
• PostgreSQL While Loop

Users, logins and permissions3

Create users, reset passwords and grant the right permissions.

• How To Delete User In PostgreSQL
• How to Set a User Password in PostgreSQL (Create, Change, Reset)
• PostgreSQL list users

Backup, import/export and administration5

Back up, restore, import, export, migrate and monitor.

• How To Take BackUp Of Postgres Database
• How to use Pgloader to Migrate MySQL Database to Postgres
• Postgres Export to CSV
• PostgreSQL ANALYZE
• PostgreSQL import SQL file

Errors and fixes3

The exact error message, what causes it and the steps that fix it.

• Could Not Connect to PostgreSQL Server
• PostgreSQL Password Authentication Failed
• Upper Bound of for Loop cannot be Null

Comparisons5

Side-by-side comparisons to help you choose.

• PostgreSQL datatype text vs varchar
• PostgreSQL Difference Between Two Timestamps
• PostgreSQL JSON vs JSONB
• PostgreSQL VACUUM vs VACUUM FULL
• PostgreSQL Vs SQLite

Other database tutorials

Looking for everything, newest first? See the full tutorial list.