Dear All,

I have been facing below issue when trying to export table data in CSV format only when used where condition.
I dont see any issue if I dont use where condition.
Eg:
Succesfully copied to CSV
Code:
dnsdb=> \copy domains to  '/root/pgdata/mycsv.csv' csv;
COPY
Failing with below error when added where condition

Code:
dnsdb=> \COPY (SELECT * FROM DOMAINS where id='20313') to
...