Getting Started

    CREATE TABLE IF NOT EXISTS products (
        id INTEGER PRIMARY KEY,
        name TEXT,
        category TEXT,
        country_code TEXT,
        price INTEGER
    );
    INSERT INTO products VALUES
        (1, 'Apple', 'Fruit', 'IN', 100),
        (2, 'Orange', 'Fruit', 'IN', 80),
        (3, 'Banana', 'Fruit', 'IN', 50),
        (4, 'Mango', 'Fruit', 'IN', 150),
        (5, 'Pineapple', 'Fruit', 'IN', 200),
        (6, 'Papaya', 'Fruit', 'IN', 100),
        (7, 'Grapes', 'Fruit', 'IN', 120),
        (8, 'Strawberry', 'Fruit', 'IN', 300),
        (9, 'Kiwi', 'Fruit', 'US', 200),
        (10, 'Watermelon', 'Fruit', 'US', 100);

    version: '3'
    services:
      dcs-demo-postgres:
        container_name: dcs-demo-postgres
        image: postgres
        environment:
          POSTGRES_DB: dcs_demo
          POSTGRES_USER: dbuser
          POSTGRES_PASSWORD: dbpass
          PGDATA: /data/postgres
        volumes:
          - dcs-demo-postgres:/data/postgres
          - ./init.sql:/docker-entrypoint-initdb.d/init.sql
        ports:
          - "5431:5432"
        networks:
          - dcs-demo-postgres
        restart: unless-stopped

    networks:
      dcs-demo-postgres:
        driver: bridge

    volumes:
      dcs-demo-postgres:
        driver: local