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 Columns
  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

pgAdmin 4 Tutorials

Database Management

  1. How to create a database in pgAdmin 4
  2. How to delete a database in pgAdmin 4
  3. How to rename a database in pgAdmin 4
  4. How to connect to a database server in pgAdmin 4
  5. How to disconnect from a database server in pgAdmin 4
  6. How to back up a database in pgAdmin 4
  7. How to restore a database in pgAdmin 4
  8. How to view database properties in pgAdmin 4
  9. How to set database connection limits in pgAdmin 4

Table Management

  1. How to create a table in pgAdmin 4
  2. How to delete a table in pgAdmin 4
  3. How to rename a table in pgAdmin 4
  4. How to modify table structure in pgAdmin 4
  5. How to add new columns to a table in pgAdmin 4
  6. How to delete columns from a table in pgAdmin 4
  7. How to create constraints on a table in pgAdmin 4
  8. How to export a table in pgAdmin 4
  9. How to import data into a table in pgAdmin 4
  10. How to truncate a table in pgAdmin 4
  11. How to analyze table dependencies in pgAdmin 4

Querying and Scripts

  1. How to write SQL queries in the query tool in pgAdmin 4
  2. How to execute a query in pgAdmin 4
  3. How to save SQL queries in pgAdmin 4
  4. How to format SQL queries in pgAdmin 4
  5. How to debug a query in pgAdmin 4
  6. How to use the Query History in pgAdmin 4

Schema Management

  1. How to create a schema in pgAdmin 4
  2. How to delete a schema in pgAdmin 4
  3. How to rename a schema in pgAdmin 4
  4. How to manage schema privileges in pgAdmin 4

User and Role Management

  1. How to create a user in pgAdmin 4
  2. How to delete a user in pgAdmin 4
  3. How to modify user roles in pgAdmin 4
  4. How to assign privileges to a user in pgAdmin 4
  5. How to revoke privileges from a user in pgAdmin 4

Index Management

  1. How to create an index in pgAdmin 4
  2. How to delete an index in pgAdmin 4
  3. How to view index properties in pgAdmin 4
  4. How to rebuild an index in pgAdmin 4

View and Function Management

  1. How to create a view in pgAdmin 4
  2. How to delete a view in pgAdmin 4
  3. How to modify a view in pgAdmin 4
  4. How to create a function in pgAdmin 4
  5. How to delete a function in pgAdmin 4
  6. How to debug a function in pgAdmin 4

Trigger Management

  1. How to create a trigger in pgAdmin 4
  2. How to delete a trigger in pgAdmin 4
  3. How to enable or disable triggers in pgAdmin 4
  4. How to view trigger properties in pgAdmin 4

Backup and Restore

  1. How to back up a database in pgAdmin 4
  2. How to restore a database in pgAdmin 4
  3. How to schedule backups in pgAdmin 4
  4. How to use pg_dump with pgAdmin 4

Maintenance and Monitoring

  1. How to analyze a database in pgAdmin 4
  2. How to vacuum a database in pgAdmin 4
  3. How to reindex a database in pgAdmin 4
  4. How to monitor database activity in pgAdmin 4
  5. How to view server logs in pgAdmin 4
  6. How to manage replication in pgAdmin 4

Import/Export

  1. How to import data from a CSV file in pgAdmin 4
  2. How to export data to a CSV file in pgAdmin 4
  3. How to export a database schema in pgAdmin 4
  4. How to export a table to JSON in pgAdmin 4

Miscellaneous Actions

  1. How to use dashboards in pgAdmin 4
  2. How to customize the pgAdmin 4 interface
  3. How to configure notifications in pgAdmin 4
  4. How to create a server group in pgAdmin 4
  5. How to configure a server connection in pgAdmin 4
  6. How to reset the master password in pgAdmin 4
  7. How to use the built-in debugger in pgAdmin 4
  8. How to enable auto-refresh in pgAdmin 4
  9. How to compare schemas in pgAdmin 4
  10. How to generate ER diagrams in pgAdmin 4