what is postgreSQL

What is postgreSQL?

PostgreSQL is a Relational Database Management System(RDBMS) is a named collection of SQL objects. It is a collection of schemas and the schemas contain the tables, functions, etc.

• Databases are created with the CREATE DATABASE command and
• Databases are destroyed with the DROP DATABASE command.

To determine the set of existing databases:

-SQL: SELECT datname FROM pg_database;

Above command will list all the databases

-psql META COMMAND: \l(backslash lowercase L)

Using \l also we can list all the databases

PostgreSQL Object Hirachy

also see below

what is postgreSQL

Why postgresSQL

History of PostgreSQL

postgreSQL - PSQL MATA Commands

postgreSQL what is schema?

postgreSQL Connecting to a Database

postgreSQL Create and access Database

How to create user in postgreSQL?

postgreSQL Grant/Revoke Privileges

postgreSQL Tablespaces and datafiles

postgreSQL How to start server and stop server?

postgreSQL perfomance

postgreSQL How to create cluster?

postgreSQL Queries

postgreSQL routine maintenance and proactive-maintanace.

postgresql-logging