| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | carsten(dot)jahn(at)bayer(dot)com |
| Subject: | psql -f switch and "COPY ... FROM STDIN" |
| Date: | 2020-05-11 16:40:16 |
| Message-ID: | 158921521630.649.5234337138274130122@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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 piped
into the psql command, which had the "COPY" sql statement in a separate
file, referenced by the -f switch. In the end, I found out that the -f
switch leads to psql ignoring all stdin - all you get is the output "COPY
0". I think it would be worth documenting this behavior of the -f / --file
switch on the psql documentation page.
Thanks + best regards,
Carsten
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-05-12 01:59:30 | Re: Remaining PDF layout issues |
| Previous Message | Simon Riggs | 2020-05-11 06:57:54 | Re: 【memory barrier】Should we update the README.barrier description. |