INSERTING "NEW LINES" IN A SELECT STATEMENT - Mailing list pgsql-novice

From JORGE MALDONADO
Subject INSERTING "NEW LINES" IN A SELECT STATEMENT
Date
Msg-id f03943a00905141203r621404ceje3ccb32013317e5f@mail.gmail.com
Whole thread Raw
Responses Re: INSERTING "NEW LINES" IN A SELECT STATEMENT
List pgsql-novice
I have a query like this:
 
SELECT field1 || field2 AS finalfield FROM table1
 
Is it possible to insert a new line between "field1" and "field2" (carriage return, line feed or something) so when "finalfield" is displayed it is shown in 2 lines?
 
My web application actually displays one line as follows depending on the internet browser:
1. The line displayed is "cut" so part of the information is not seen.
2. All of the information is displayed but the horizontal scrolling bar appears to "move the screen" to the right and read the complete information.
 
With respect,
Jorge Maldonado

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unexpected behaviour of ORDER BY and LIMIT/OFFSET
Next
From: Ognjen Blagojevic
Date:
Subject: Re: Unexpected behaviour of ORDER BY and LIMIT/OFFSET