Re: [SQL] how to preserve \n in select statement

2003-12-20 Thread Tom Lane
"Matt Van Mater" <[EMAIL PROTECTED]> writes: >> In particular, you have to separate data from SQL command if you want a >> no-escape-processing behavior for data. > right, I was looking for the alternate input methods that you allude to. I > have been unable to find an example of exactly how to

Re: [SQL] how to preserve \n in select statement

2003-12-20 Thread Matt Van Mater
Because you are using an input syntax that requires that quotes and backslashes be escaped. There are other input methods available that don't require this, but they have disadvantages of their own. In particular, you have to separate data from SQL command if you want a no-escape-processing behav