Abdullamhd/postgres_setup

Postgres Setup with Docker

Configuring PostgreSQL with pgAdmin 4 in Docker & understanding the data

Clone the repository

git clone https://github.com/Abdullamhd/postgres_setup.git

Change directory to the repository

cd postgres_setup

Run the docker-compose file

docker-compose up -d

Open the browser and go to the following link

http://localhost:5050

Login with the following credentials

email:localhost@localhost.com
password:123456

Create a new server

name:postgres
host:db
port:5432
username:postgres
password:postgres

---

get to know the data

Select all employees from the employees table

SELECT * FROM employees;

select all customers from the customers table

SELECT * FROM customers;

select all products and categories from the products and categories tables

SELECT * FROM products;
SELECT * FROM categories;

Select all suppliers from the suppliers table

SELECT * FROM suppliers;

Select all from the orders table

SELECT * FROM orders;

Select all from the order_details table

SELECT * FROM order_details;

Select all from the employees territories table

SELECT * FROM employees_territories;

Select all from the customer_demographics table

SELECT * FROM customer_demographics;

Select all from the region table

SELECT * FROM region;

Select all from shippers table

SELECT * FROM shippers;