mkdir postgresql_data

docker volume create postgresql_data

version: '3.8'
services:
  pg_database:
    image: postgres:14.9-alpine
    restart: always
    volumes:
      - ./postgresql_data:/var/lib/postgresql/data
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
      - POSTGRES_DB=postgres
    ports:
      - '5455:5432'
volumes:
  postgresql_data:

docker-compose up --build -d

sudo apt install postgresql-client

psql -U postgres -p 5455 -h localhost;

create database ecommerce_crud;

psql -U postgres -p 5455 -h localhost -d nodalnda < nodal_dump_local2024_04_29_20_00.sql

 \l ; is same as show databases in mysql;
 \d+ products; is same as show create table products ;
 \c morning_fresh_bakery; same as  use country_db in mysql;
 \dt; show tables in mysql;
 \d users describe table;

DROP DATABASE nodalnda WITH (FORCE);