HISTORY-->
-PostgreSQL's history began in 1986 as a research project called POSTGRES at the University of California, Berkeley -1986 – POSTGRES Project
-The goal was to create a more advanced database system that could overcome some limitations of traditional relational databases.
1994 – SQL Support
-In 1994, two Berkeley students, Andrew Yu and Jolly Chen, added an SQL language interpreter to POSTGRES.
-The project was renamed Postgres95.
1996 – PostgreSQL ->For showing it supports Sql
What is PostgreSQL?
PostgreSQL is an open-source relational database management system (RDBMS) used to store, manage, and retrieve data.
It is commonly called Postgres.
PostgreSQL uses SQL (Structured Query Language) to communicate with the database.
ORDBMS->Object Relational Database Management System
-sending object as an argument
Database
A database is an organized collection of data.
DBMS-->Software to communnicate with database
Two Types
-RDBMS(Relational)
-NRDBMS(Non Relational )
RDBMS:
*Values stored in table formate(Rows annd columns)
Example:Mysql.Oracle
NRDBMS:
-Values stored in document .graph etc other than table
Example:MongoDB,Neo4j,Apache
INSTALLATION IN TERMINAL:
1. sudo apt update
2. sudo apt install postgresql postgresql-contrib
3. sudo systemctl status postgresql
4. sudo systemctl enable postgresql
5. sudo -i -u postgres
6.PSQL
Top comments (0)