DEV Community

ranjithmanimekalai
ranjithmanimekalai

Posted on

POSTGRESQL

PostgreSQL
*It was first released in 1989 as a project at the University of California, Berkeley.
*PostgreSQL is an advanced relational database system.

      *PostgreSQL supports both relational (SQL) and non-relational (JSON) queries.

        *PostgreSQL is free and open-source.

        5. Data Storage
Enter fullscreen mode Exit fullscreen mode

Data is stored in tables (rows & columns).

Each table belongs to a schema.

Schemas belong to a database.

Data files are stored in the data directory on disk.

Indexes improve query performance (B-tree, Hash, GIN, GiST, BRIN).

   (1)PostgreSQL as Object-Relational Database (ORDBMS)

    Unlike a normal RDBMS (like MySQL), PostgreSQL supports object features inside relational tables. That’s why it’s called object-relational.

Examples of ORDBMS:
Enter fullscreen mode Exit fullscreen mode

PostgreSQL (most popular open-source ORDBMS)

Oracle (from version 8 onwards)

IBM Db2

Informix

Examples of RDBMS:

MySQL

Microsoft SQL Server

Oracle (basic relational features)

PostgreSQL (can also act as pure RDBMS)

Reffer:
https://www.w3schools.com/postgresql/

Top comments (0)