From: | Euler Taveira <euler(at)timbira(dot)com(dot)br> |
---|---|
To: | sfbarbee(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: FORMAT keyword not allowed in COPY ... FROM statement |
Date: | 2019-02-25 14:37:32 |
Message-ID: | CAHE3wggi2v=yHg2noWH54S9v0u=Ux-iwVUEe73x8vu2=f45WBw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Em sex, 22 de fev de 2019 às 06:31, PG Doc comments form
<noreply(at)postgresql(dot)org> escreveu:
>
> The following documentation comment has been logged on the website:
> # COPY table_name FROM '/srv/database/pg_dumps/file.csv' WITH FORMAT CSV
> HEADER DELIMITER ',' QUOTE '"' ;
> ERROR: syntax error at or near "FORMAT"
>
Your command is wrong. Please check synopsis in [1]. Use the new
syntax (options should be inside parentheses and separated by comma).
> # COPY table_name FROM '/srv/database/pg_dumps/file.csv' WITH CSV HEADER
> DELIMITER ',' QUOTE '"' ;
> COPY 63
>
This is the old syntax (check Compatibility section at the end of [1]).
[1] https://www.postgresql.org/docs/11/sql-copy.html
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
From | Date | Subject | |
---|---|---|---|
Next Message | PG Doc comments form | 2019-02-27 06:43:02 | With statements does not modify original table untill it is "complete" |
Previous Message | Jürgen Purtz | 2019-02-23 17:06:55 | Re: First SVG graphic |