Skip to content
Related Articles
Open in App
Not now

Related Articles

PostgreSQL Tutorial

Improve Article
Save Article
  • Difficulty Level : Hard
  • Last Updated : 23 Feb, 2021
Improve Article
Save Article

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
Related Articles

Start Your Coding Journey Now!