IE: psql -U myusername mydatabase -f '/path/to/commandfile'
Inside the commandfile I have lines like: INSERT INTO tablename (col1, col2, col3) VALUES ($val1, $val2, $val3);
How do I escape the data from a select statement? Something like: SELECT \* FROM tablename; ?
----Original Message Follows---- From: Guy Fraser <[EMAIL PROTECTED]> To: Matt Van Mater <[EMAIL PROTECTED]> Subject: Re: [SQL] how to preserve \n in select statement Date: Fri, 19 Dec 2003 08:43:59 -0700
What are you using to enter and retrieve the data?
Either escape the data before you put it in the database or when you retieve it, whichever gives you the results you are looking for.
Matt Van Mater wrote:
I have a table that has a few text value types, and I enter a bunch of text with '\n' representing a newline. When I select the records from that table, postgresql 7.3 represents those \n as newlines and actually outputs the a newline rather than as a \n as entered. I want to be able to get my \n text out of the select statement in the exact same manner it was inserted.
I found a workaround where I can use the copy to command to copy a table to a text file, and the command preserves the \n characters. The problem with that is the copy to command overwrites the output file every time it is written to. That stinks because then I can't run multiple queries and direct the output to a file all at once. (I would prefer to set the output file as \o '/path/to/oufile.txt' and have all queries dump their results there)
Is there a way to make the select statement not interpret newline escape characters?
Matt Van Mater
_________________________________________________________________
Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html