Sample Header Ad - 728x90

export data from postgresql

2 votes
1 answer
232 views
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