Skip to content
Related Articles
Get the best out of our app
GeeksforGeeks App
Open App

Related Articles

PostgreSQL Tutorial

Improve Article
Save Article
Like Article
Improve Article
Save Article
Like 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.

In this PostgreSQL tutorial you’ll learn the basic data types like Boolean, char, text, time, int, etc., Querying and Filtering techniques like select, where, in, order by, etc. managing and modifying the tables in PostgreSQL. We’ll cover all the basic to advance concepts of PostgreSQL in this tutorial.

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

Advantages of PostgreSQL

  • PostgreSQL has the feature of write-ahead logging.
  • Many replication methods are supported.
  • It has ability to make large-scale web applications because it is robust and powerful.
  • It is easy to learn.
  • According to the organization we can edit and modify it easily because PostgreSQL is available for free to its open source license.

FAQs on PostgreSQL

Q.1 How to create new Database in PostgreSQL?


There are two methods of creating a new database:

  1. CREATE DATABASE (SQL command)
  2. createdb (command-line executable)

Q.2 What are the different Operators in PostgreSQL?


It includes :

  • Arithmetic operators
  • Logic operators
  • Comparison operators
  • Bitwise operators

Q.3 What are the disadvantages with PostgreSQL?


Performance wise PostgreSQL is slower than MySQL and Open source applications are less than MySQL.

Q.4 How to delete a PostgreSQL database?


  1. DROP DATABASE (SQL command)
  2. dropdb (command-line)

My Personal Notes arrow_drop_up
Last Updated : 03 Apr, 2023
Like Article
Save Article
Similar Reads