Copy csv into container to use in init.sql

Question

i need to create a container with PostgreSQL and i have a file init.sql which contains the structure of the DB and at the end a command to copy data from a CSV.

My init.sql is:

CREATE SEQUENCE aditivo_id_seq;

CREATE TABLE public.aditivo
(
   id               BIGINT NOT NULL DEFAULT nextval ('aditivo_id_seq'::regclass),
   clasificacion    CHARACTER VARYING (200) NOT NULL,
   descripcion      CHARACTER VARYING (4000) NOT NULL,
   id_aditivo       CHARACTER VARYING (10) NOT NULL,
   nombre           CHARACTER VARYING (200) NOT NULL,
   origen           CHARACTER VARYING (40) NOT NULL,
   peligro          CHARACTER VARYING (200) NOT NULL,
   CONSTRAINT aditivo_pkey PRIMARY KEY (id)
      NOT DEFERRABLE INITIALLY IMMEDIATE,
   CONSTRAINT uk_c1t6nik8nbqfei52k7rlo28lv UNIQUE (id_aditivo)
      NOT DEFERRABLE INITIALLY IMMEDIATE
);

COPY aditivo (clasificacion, descripcion, id_aditivo, nombre, origen, peligro) FROM '/var/lib/postgresql/csvs/aditivos.csv' DELIMITER ',' CSV HEADER;

And my docker-compose.yml is:

version: "3.3"
services:
  postgreSQL:
    restart: on-failure
    image: postgres:latest
    volumes:
      - ./postgres/aditivos.csv:/var/lib/postgresql/csvs
      - ./postgres/init.sql:/docker-entrypoint-initdb.d/init.sql
    environment:
      POSTGRES_USER: UALappDitivos
      POSTGRES_PASSWORD: TFGappDitivosUAL!
      POSTGRES_DB: db
    ports:
      - "5432:5432"

The init.sql is copied ok, but the csv no.

I get the error:

psql:/docker-entrypoint-initdb.d/init.sql:147: ERROR: could not open file "/var/lib/postgresql/csvs/user.csv" for reading: Not a directory

How can i do this correctly?

SantiSori · Accepted Answer · 2019-06-28 15:25:18Z

4

To solve this, i copy the folder instead to copy the file.csv. So my docker-compose.yml looks like:

version: "3.3"
services:
  postgreSQL:
    restart: on-failure
    image: postgres:latest
    volumes:
      - ./init.sql:/docker-entrypoint-initdb.d/init.sql
      - ./postgres/csvs:/var/lib/postgresql/csvs
    environment:
      POSTGRES_USER: UALappDitivos
      POSTGRES_PASSWORD: TFGappDitivosUAL!
      POSTGRES_DB: db
    ports:
      - "5432:5432"
  rest:
    build: rest
    restart: on-failure
    depends_on: 
      - postgreSQL
    ports:
      - "8080:8080"

answered Jun 28, 2019 at 15:25

SantiSori

4115 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Copy csv into container to use in init.sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related