Syntax error postgresql

Question

I have a syntax error on Postgresql:

The error :

ERROR:  syntax error at or near "\"
LINE 19066: \.
            ^
********** Erreur **********

ERROR: syntax error at or near "\"
État SQL :42601
Caractère : 678313

And the offending line

COPY accesslog (aid, sid, title, path, url, hostname, uid, timer, "timestamp") FROM stdin;
\.

Do you have an idea what's wrong?

Why would you not show the actual error? What possible reason can there be for hiding it? — Richard Huxton
– Richard Huxton, Commented Feb 27, 2014 at 15:50
Sorry, I indicated the line affected by the error, but not the error in fact, here's the error: ERROR: syntax error at or near "\" LINE 19066: \. ^ ********** Erreur ********** ERROR: syntax error at or near "\" État SQL :42601 Caractère : 678313 — Fluidouix
– Fluidouix, Commented Feb 27, 2014 at 16:02
Thank you for your answer Houari. I execute this command in pgadmin, to make a dump of my database — Fluidouix
– Fluidouix, Commented Feb 27, 2014 at 19:10

Craig Ringer · Accepted Answer · 2014-02-28 00:39:03Z

1

PgAdmin-III doesn't support interactive line-by-line COPY. Use psql.

That said, I think you are trying to COPY data FROM the server, not to it. If that's the case, either use COPY ... TO 'some-file-name' (a path relative to the database server), use pg_dump, or use psql with \copy.

answered Feb 28, 2014 at 0:39

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

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

Collectives™ on Stack Overflow

Syntax error postgresql

1 Answer 1

Comments

Hot Network Questions