Postgres Pro
Downloads
Home   >   mailing lists

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

From JORGE MALDONADO
Subject How to insert a carriage return and line field between fields in a query
Date
Msg-id CAAY=A79EJK6_kKTNOySKnJ73LpxUdcq-JBM+ZxkpwidWtjweoA@mail.gmail.com
Whole thread Raw
Responses Re: How to insert a carriage return and line field between fields in a query
List pgsql-sql
Tree view
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.

pgsql-sql by date:

Previous
From: Alex Ignatov
Date:
Subject: Re: Strange DOMAIN behavior
Next
From: "David G. Johnston"
Date:
Subject: Re: How to insert a carriage return and line field between fields in a query