Re: How to insert a carriage return and line field between fields in a query - Mailing list pgsql-sql

I have a query like the following:

SELECT fld1 || fld2

I need to insert a carriage return (\r) and a line feed (\n) after each field. How can I do this?

I tried 

SELECT fld1 || \r\n || fld2 || \r\n 

and also 

SELECT fld1 || '\r\n' || fld2 || '\r\n'

without success.

I will very much appreciate your feedback.