Page 1 of 1

SQL query - data output (newlne command) help

PostPosted: Tue May 01, 2012 7:59 pm
by 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

Re: SQL query - data output (newlne command) help

PostPosted: Wed May 02, 2012 8:45 am
by kraada
I'm afraid I'm not aware of a way to do that - have you considered asking on the PostgreSQL mailing lists?

Re: SQL query - data output (newlne command) help

PostPosted: Wed May 02, 2012 5:31 pm
by ipsy
kraada wrote: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.