I have some text like xml -code in a field of table. I want to export the data from my field into file without any changes.
I've tried to use a lot of variants but all of them changes the text. The most successful variants were:
COPY (SELECT alll FROM super.a_a ) TO 'D:\alll.txt' CSV ;
But there appeared extra quotes "".
COPY (SELECT alll FROM super.a_a ) TO 'D:\alll.txt CSV QUOTE ' ' ;
But there appeared extra spaces.
In my field I have such date like : name="firsname" and when I use any of varients I get something like that : name=""firstname"" or name=\n\r"firstname\n\r""
CSV
to export to the pure text format.