Re: COPY FROM

2022-06-10 Thread David G. Johnston
On Fri, Jun 10, 2022 at 3:40 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/sql-copy.html > Description: > > When copying a csv file into a table, ifthere is a string missing a double > quote in the

COPY FROM

2022-06-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-copy.html Description: When copying a csv file into a table, ifthere is a string missing a double quote in the end, COPY will return an error saying the string is infinitely long. But

psql -f switch and "COPY ... FROM STDIN"

2020-05-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/app-psql.html Description: Hi, first of all thanks for the great postgres database and its psql utility. Today I had some trouble using "COPY ... FROM STDIN" with CSV data pipe

COPY FROM needs better example

2019-11-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-copy.html Description: The example shown for COPY FROM is very basic and doesn't show how to use any of the options -- which have tricky syntax that seems to trip up a numb

Re: FORMAT keyword not allowed in COPY ... FROM statement

2019-02-25 Thread Euler Taveira
Em sex, 22 de fev de 2019 às 06:31, PG Doc comments form 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

FORMAT keyword not allowed in COPY ... FROM statement

2019-02-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-copy.html Description: > psql --version ; psql (PostgreSQL) 11.2 > initdb --version ; initdb (PostgreSQL) 11.2 # \h copy Command: COPY Description: copy data between a file and a

HEADER [ boolean ] not allowed in COPY ... FROM statement

2019-02-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-copy.html Description: > psql --version ; psql (PostgreSQL) 11.2 > initdb --version ; initdb (PostgreSQL) 11.2 The boolean parameter is not allowed in the statement: # COPY table_nam