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