I have a table in my database that contains data with three columns: I would, Surname, and Remarks, The Remarks This column contains unstructured text data that should be exported as a separate text file for each line. That is, if I had 5 lines in my spreadsheet, I would export 5 .txt files. Here is my previous attempt:
$$ do to explain Arow Record; Files varchar; begin for arow in Select the ID, the name and the note loop Files: = & # 39; / tmp / & # 39 ;|| arow.id || & # 39; & # 39 ;|| arow.name || & # 39; txt & # 39 ;; COPY (select the note from the multiple text with id = arow.id) TO files (FORMAT CSV); end loop; The End; $$;
Currently there is one
ERROR: syntax error on or near "files", I am using PostgreSQL in pgadmin. Any help is greatly appreciated!