SQLFiddle here: http://sqlfiddle.com/#!15/e8e49/2/0
I want to get some summary data from my table into rows instead of columns..
select
sum(n),
avg(n),
max(n),
min(n)
from Table1
this returns a single row, multi-column result.
How can I get it into a result that's something like this:
Label | Res
-------------
min | 2
max | 3
count | 30
... etc ...
Postgres does not have a pivot trasformation...
or if you have superuser can try CREATE EXTENSION tablefunc