On 3/24/23 17:14, David G. Johnston wrote:
On Fri, Mar 24, 2023 at 4:04 PM Rob Sargent wrote:
Using version 13 psql on version 14 server and having trouble
sending a multi-line select in the \copy. I don't see any remark
about this in the man page.
The copy meta-command cannot co
On Fri, Mar 24, 2023 at 4:04 PM Rob Sargent wrote:
> Using version 13 psql on version 14 server and having trouble sending a
> multi-line select in the \copy. I don't see any remark about this in the
> man page.
>
The copy meta-command cannot contain newlines. You should use "COPY ... TO
STDOU
Using version 13 psql on version 14 server and having trouble sending a
multi-line select in the \copy. I don't see any remark about this in
the man page.
\copy (
select a.mrn, a.relationship,a.relation_mrn,a.provided_relationship
from actual_and_inf_rel_part1_unique_clean a
join family_ids f