Verver:

My query is as follows:

SELECT col1 AS "a Long Striiiiiiiiiiiiiiing1" 
FROM table1 

(I'm asked to use that long string for column header) is there and way to inject a carriage return in column header so that it be displayed as:

a long striii
iiiiiiiiiing

My Postgresql version is 8.4. And I have tried Followings, and none of them works:

  SELECT col1 AS U&"a Long Striiii\n iiiiiiiiiiing1" 
        FROM table1 
    SELECT col1 AS E"a Long Striiii\r\n iiiiiiiiiiing1" 
        FROM table1 
SELECT col1 AS E"a Long Striiii\000 iiiiiiiiiiing1" 
        FROM table1 
SELECT col1 AS U&"a Long Striiii\000 iiiiiiiiiiing1" 
        FROM table1