Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

PostgreSQL Tutorial

  • Difficulty Level : Hard
  • Last Updated : 23 Feb, 2021

PostgreSQL is one of the most advanced general-purpose object-relational database management systems, and it is open-source. Being open-source software, its source code is available under PostgreSQL license, a liberal open source license. Anyone with the right skills is free to use, modify, and distribute PostgreSQL in any form.


Contemporary relational databases like MySQL, MariaDB, Apache Hive, etc all operate on the similar principle of establishing relationships among data, but PostgreSQL has additional features like table inheritance and function overloading as PostgreSQL supports the concept of Data objects.

Table of Content



Data Types

Querying & Filtering Data

Managing Tables

Modifying Data


Control Flow

Transactions & Constraints

Working with JOINS & Schemas

Roles & Permissions

Working with Sets

Subquery & CTEs

User-defined Functions

Important In-Built Functions

Visit PostgreSQL In-Built functions for more.

PostgreSQL Advance Concepts

PostgreSQL PL/pgSQL

Variables & Constants

Stored Procedures

Working with Triggers

Working with Views & Indexes

Errors & Exception Handling

My Personal Notes arrow_drop_up
Recommended Articles
Page :