0

I have a problem with PostgreSQL script runing with docker-compose. I want to create only ONE table in PostgreSQL.

My script is:

DROP TABLE IF EXISTS person;
CREATE TABLE person
(
    id      INT NOT NULL,
    name    VARCHAR(255),
    surname VARCHAR(255),
    age     INT,
    email   VARCHAR(255) UNIQUE
);

Log from drocker-compose Error message is:

postgres     | Success. You can now start the database server using:
postgres     |
postgres     |     pg_ctl -D /var/lib/postgresql/data -l logfile start
postgres     |
postgres     | waiting for server to start....2022-07-11 08:39:50.970 UTC [48] LOG:  starting PostgreSQL 14.4 (Debian 14.4-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
postgres     | 2022-07-11 08:39:50.978 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres     | 2022-07-11 08:39:51.000 UTC [49] LOG:  database system was shut down at 2022-07-11 08:39:50 UTC
postgres     | 2022-07-11 08:39:51.008 UTC [48] LOG:  database system is ready to accept connections
postgres     |  done
postgres     | server started
postgres     | CREATE DATABASE
postgres     |
postgres     |
postgres     | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/create-table-person.sql
postgres     | 2022-07-11 08:39:51.431 UTC [62] ERROR:  syntax error at or near "CREATE" at character 30
postgres     | 2022-07-11 08:39:51.431 UTC [62] STATEMENT:  DROP TABLE IF EXISTS person
postgres     |  CREATE TABLE person
postgres     |  (
postgres     |      id      integer NOT NULL PRIMARY KEY,
postgres     |      name    VARCHAR(255),
postgres     |      surname VARCHAR(255),
postgres     |      age     integer,
postgres     |      email   VARCHAR(255)
postgres     |  );
postgres     | psql:/docker-entrypoint-initdb.d/create-table-person.sql:9: ERROR:  syntax error at or near "CREATE"
postgres     | LINE 2: CREATE TABLE person
postgres     |         ^
postgres exited with code 3

and my Dockerfile for PostgreSQL is:

FROM postgres
ENV POSTGRES_DB testdatabase1

COPY create-table-person.sql /docker-entrypoint-initdb.d/
Improve this question
3
  • stackoverflow.com/questions/66713670/… Looks like a similar problem to the one I'm linking above Commented Jul 11, 2022 at 8:53
  • It works for me, when I try to reproduce it. Since it complains on line 2 of your script, I'm thinking that you might have saved the script with Windows CRLF line endings instead of Linux LF line endings. Commented Jul 11, 2022 at 9:08
  • Ok thanks. i dont know why, but its works. Commented Jul 12, 2022 at 13:13
Related questions
336
PostgreSQL create table if not exists
0
Postgresql Drop Table If exists
3
Postgresql: create a table and delete if exist
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.