Training Trains Internship
Student login
← PostgreSQL learning path
PostgreSQL · Module 1 of 10

Introduction to PostgreSQL

PostgreSQL is a powerful open-source relational database.

📖 Key ideas

  1. PostgreSQL (Postgres) is an advanced open-source relational database.
  2. It follows SQL standards and adds features like JSONB, arrays and extensions.
  3. Connect with psql, pgAdmin or DBeaver.
  4. Default port is 5432.
  5. Used by Instagram, Reddit and many startups; managed by Supabase, Neon, RDS, Cloud SQL.
💡 Real-life example: PostgreSQL is a Swiss Army knife database: tables plus many extra tools folded inside.
PostgreSQLOpen-source relational database
psqlCommand-line client
pgAdminGUI admin tool
5432Default port