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 on f.individual_id in (a.mrn, a.relation_mrn)
where f.family_id = 1954 and relationship != 'Child'
union
select a.relation_mrn, case when d.sex = 'M' then 'Father' when
d.sex = 'F' then 'Mother' else 'Parent' end, a.mrn,
a.provided_relationship
from actual_and_inf_rel_part1_unique_clean a
join family_ids f on f.individual_id in (a.mrn, a.relation_mrn)
join pt_demog d on a.mrn = d.mrn
where f.family_id = 1954 and relationship = 'Child'
)
to /some/long/path/emp1954/1954rel.csv csv header delimiter E'\t'
\copy: parse error at end of line
select a.mrn,
a.relationship,a.relation_mrn,a.provided_relationship
from actual_and_inf_rel_part1_unique_clean a
join family_ids f on f.individual_id in (a.mrn, a.relation_mrn)
where f.family_id = 1954 and relationship != 'Child'
union
select a.relation_mrn, case when d.sex = 'M' then 'Father' when
d.sex = 'F' then 'Mother' else 'Parent' end, a.mrn,
a.provided_relationship
from actual_and_inf_rel_part1_unique_clean a
join family_ids f on f.individual_id in (a.mrn, a.relation_mrn)
join pt_demog d on a.mrn = d.mrn
where f.family_id = 1954 and relationship = 'Child';
mrn | relationship | relation_mrn
| provided_relationship
---------+------------------------------------------+--------------+-----------------------
70971 | Great-grandchild | 2673727
|
1518425 | Mother | 70971
| 1
851744 | Mother | 918639
| 1
2629602 | Father | 959532
| 1
2981293 | Mother | 1135789
| 1
2629602 | Mother | 439681
| 1
70971 | Great-grandchild | 2811064
|
2714530 | Father | 851744
| 1
2520718 | Grandchild | 2029421
| 1
339921 | Mother | 1135789
| 1
2520718 | Grandchild | 339921
|
2981293 | Father | 851744
| 1
2029421 | Mother | 439681
| 1
918639 | Grandchild | 3696817
|
70971 | Great-grandchild | 339921
|
439681 | Spouse | 959532
| 1
339921 | Father | 851744
| 1
2520718 | Grandchild/Grandchild-in-law | 3731101
|
2520718 | Grandchild | 2673727
|
918639 | Grandchild | 2673727
|
70971 | Great-grandchild | 2981293
|
918639 | Grandchild | 339921
|
1341357 | Spouse | 2520718
| 1
70971 | Grandchild | 1135789
|
2520718 | Grandchild | 2981293
|
3696817 | Father | 851744
| 1
2520718 | Mother | 70971
| 1
1135789 | Mother | 2520718
| 1
918639 | Grandchild | 2714530
|
3468386 | Mother | 2694687
| 1
3594047 | Mother | 2694687
| 1
1552075 | Spouse | 3731101
| 1
2714530 | Mother | 2694687
| 1
2673727 | Mother | 1135789
| 1
1135789 | Nephew/Niece | 3731101
| 1
70971 | Great-grandchild | 2029421
|
918639 | Grandchild | 2981293
|
70971 | Great-grandchild/Great-grandchild-in-law | 3731101
|
2520718 | Grandchild | 2811064
| 1
2673727 | Father | 851744
| 1
(40 rows)
