PostgresSQL 8.4 - Data output - Newline - Mailing list pgsql-novice

From Paul .
Subject PostgresSQL 8.4 - Data output - Newline
Date
Msg-id COL110-W548D7248CC77BE3A8E6F0E882E0@phx.gbl
Whole thread Raw
Responses Re: PostgresSQL 8.4 - Data output - Newline
List pgsql-novice
Made a SQL query that i run. However the data output is bit nasty to read since the lenght of it so i want break it into a new line to make it easier to read. I understood i could do this by using a newline command but the ones i found hasnt worked (they just create a new empty column).For instance: ' \n ' , E ' \n '.

Anyone can help me out here what it is i need to use?

To make it clear, say i have 2 columns only (VPIP and PFR). Now data output when i run the query is
VPIP PFR
15 13

I want to be able to make the data output to be
VPIP
15
PFR
13

// Dan

pgsql-novice by date:

Previous
From: e-letter
Date:
Subject: Re: apply limit to sum function
Next
From: Josh Kupershmidt
Date:
Subject: Re: PostgresSQL 8.4 - Data output - Newline