PostgreSQL is a powerful, open-source relational database management system (RDBMS).
It is used to store, organize, retrieve, and manage data.
PostgreSQL uses SQL (Structured Query Language) to communicate with relational databases.
In simple words:
PostgreSQL is database software that helps us create databases and manage information using SQL.
Open-source software is software whose source code is available under a license that allows users to use, study, modify, and distribute it according to the license terms.
PostgreSQL is available free of charge under the PostgreSQL License, a permissive open-source license.
SQL stands for Structured Query Language.
It is used to communicate with relational database systems.
Using SQL, we can:
After connecting to a PostgreSQL database, we can execute an SQL command.
SELECT version();
This command displays information about the installed PostgreSQL version.
Another simple query is:
SELECT 'Hello, PostgreSQL!';
Expected result:
| ?column? |
|---|
| Hello, PostgreSQL! |
SELECT 'Hello, PostgreSQL!';
SELECT is an SQL command used to retrieve or calculate a result.'Hello, PostgreSQL!' is a text value.; marks the end of the SQL statement.PostgreSQL is used in:
SELECT version();?