PostgreSQL Tutorial

Welcome to PostgreSQL Tutorials by TutorialKart!

Get Started

Begin your journey with PostgreSQL through these beginner-friendly tutorials. Learn how to install PostgreSQL, use the GUI application pgAdmin, and work with the PostgreSQL Shell (psql).

  1. PostgreSQL – Install on Mac
  2. PostgreSQL – Install on Windows
  3. PostgreSQL – psql Shell

Database

PostgreSQL databases are collections of schemas, tables, procedures, functions, sequences, and more. Explore the following tutorials to learn how to create, manage, and delete databases effectively.

  1. PostgreSQL – Create Database
  2. PostgreSQL – Select Database
  3. PostgreSQL – List Databases
  4. PostgreSQL – Delete or Drop Database
  5. PostgreSQL – Backup and Restore Databases

Table

Learn how to manage tables in PostgreSQL. A table stores data in rows and columns. These tutorials guide you on creating tables, altering their properties, and performing operations like inserting, updating, selecting, and deleting rows.

  1. PostgreSQL – CREATE TABLE
  2. PostgreSQL – INSERT INTO Table
  3. PostgreSQL – Insert Multiple Rows into Table
  4. PostgreSQL – Insert Row if Not Exists in Table
  5. PostgreSQL – Insert JSON into Table
  6. PostgreSQL – Insert into Select from Another Table
  7. PostgreSQL – SELECT FROM Table
  8. PostgreSQL – Select Top 10 Rows from Table
  9. PostgreSQL – Select Query with Where Clause
  10. PostgreSQL – Select Distinct on One Column
  11. PostgreSQL – Select Distinct on Multiple Column
  12. PostgreSQL – Select Count
  13. PostgreSQL – UPDATE Table
  14. PostgreSQL – DELETE Rows from Table
  15. PostgreSQL – Add a Column to Table
  16. PostgreSQL – Delete a Column from Table
  17. PostgreSQL – Make a Column PRIMARY KEY
  18. PostgreSQL – Foreign Key Constraints

Clauses

  1. PostgreSQL – WHERE Clause
  2. PostgreSQL – LIMIT Clause
  3. PostgreSQL – ORDER BY Clause
  4. PostgreSQL – GROUP BY Clause
  5. PostgreSQL – HAVING Clause

More Tutorials on Creating Tables

  1. PostgreSQL – Create Table if Not Exists
  2. PostgreSQL – Create Table with Autoincrement id
  3. PostgreSQL – Create Table with Primary Key
  4. PostgreSQL – Create Table with Primary Key Autoincrement
  5. PostgreSQL – Create Table with Foreign Key
  6. PostgreSQL – Create Table with Multiple Foreign Key
  7. PostgreSQL – Create Table with Date Column
  8. PostgreSQL – Create Table with Default Timestamp
  9. PostgreSQL – Create Table with Index
  10. PostgreSQL – Create Table from Another Table

PostgreSQL – Working with JSON

  1. PostgreSQL – JSON Datatype
  2. PostgreSQL – JSONB Datatype
  3. PostgreSQL – JSON vs JSONB
  4. PostgreSQL – Select JSON column as Text
  5. PostgreSQL – JSON Functions
  6. PostgreSQL – JSON Array to Rows

Advanced Topics

  1. PostgreSQL – Views
  2. PostgreSQL – Triggers
  3. PostgreSQL – Stored Procedures
  4. PostgreSQL – Partitioning Tables
  5. PostgreSQL – JSON and JSONB Data Types
  6. PostgreSQL – Working with Arrays
  7. PostgreSQL – Full-Text Search