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""
Asked by bable
(21 rep)
Jun 29, 2016, 12:30 PM
Last activity: May 31, 2025, 01:04 AM
Last activity: May 31, 2025, 01:04 AM