themicster
commented
1 year ago Okay, additional information: After analyzing the output further it appears almost everything after column 22 is wrong in the CSV output but is correct in tab. Also it seems to be intermittent. Sometimes it works and sometimes not.
Describe the bug When using the copy selected as comma separated I get some bad values when they are clearly different in the output and they are correct when using copy as tab separated. Most are correct but the one I've got is a boolean that is true in the result set but when copied as comma separated the value is False.
To Reproduce Steps to reproduce the behavior: I haven't figured out specific repro case yet, but I'm calling a postgresql function select * from fn_get_extensions(...) and it returns about 75 rows of various types.
Expected behavior Copy as Tab Separated and Copy as Comma Separated should return the same results from the values in the selected rows.
Screenshots Can't, contains secrets.
Environment details (please complete the following information):
Additional context Nothing that I can think of.