SQL query - data output (newlne command) help

[ipsy]

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 (the 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

[kraada]

I'm afraid I'm not aware of a way to do that - have you considered asking on the PostgreSQL mailing lists?

[ipsy]

I'm afraid I'm not aware of a way to do that - have you considered asking on the PostgreSQL mailing lists?

ty ye, will try there.

i know u can do it cause i made it work some month ago but im awful saving stuff i do and lost it. anyways will write back if any intrest when i find out.