• Post category:StudyBullet-6
  • Reading time:4 mins read


Explore and Interact with PostgreSQL with PgAdmin

What you will learn

PostgreSQL Database Setup on Windows , Mac , Linux

Connect to PostgreSQL with PgAdmin

Load sample database into PostgreSQL

Explore database objects in PostgreSQL

Create Database

Create Table

Description

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.

PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.

PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.


Get Instant Notification of New Courses on our Telegram channel.


pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. pgAdmin may be used on Linux, Unix, macOS and Windows to manage PostgreSQL and EDB Advanced Server 10 and above.

The PostgreSQL is a database engine implementing SQL standards. It usually listen as a server on a network tcp port to provide its abilities. The pgAdmin is a sort of client. You are able to manipulate schema and data on an instance or multiple instances of PostgreSQL engines.

Pgadmin tool can be used to connect to and interact with PostgreSQLΒ  Server and databases.

English
language

Content

PostgreSQL | PgAdmin Setup

Introduction
What is PostgreSQL
What is PgAmin
Installing Python on Windows
Installing Python on Macs
Installing Python on Linux
Install PgAdmin for Macs
Install PgAdmin for Linux
Connect PgAmin to PostgreSQL
Install Sample Database
Database Concepts

Exploring PostgreSQL Database Objects with PgAdmin

Server Service
Database
Table
Schema
Tablespace
Views
Functions
Cast and Operators
Sequences
Extensions
Create a database with PgAdnin
Create a table with PgAdmin