2015-08-10 6:04 GMT+02:00 David Fetter <da...@fetter.org>: > On Sun, Aug 09, 2015 at 07:29:40PM +0200, Daniel Verite wrote: > > Hi, > > > > I want to suggest a client-side \pivot command in psql, implemented > > in the attached patch. > > > > \pivot takes the current query in the buffer, execute it and > > display it pivoted by interpreting the result as: > > > > column1 => row in pivoted output > > column2 => column in pivoted output > > column3 => value at (row,column) in pivoted ouput > > This is really neat work, and thanks for the patch. > > This issue in this one as in the crosstab extension is that it's > available only if you are using some particular piece of extra > software, in this case the psql client. > > I'm working up a proposal to add (UN)PIVOT support to the back-end. > Would you like to join in on that? >
PIVOT, UNPIVOT should be preferred solution Pavel I can look on implementations in other db > > Cheers, > David. > -- > David Fetter <da...@fetter.org> http://fetter.org/ > Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter > Skype: davidfetter XMPP: david.fet...@gmail.com > > Remember to vote! > Consider donating to Postgres: http://www.postgresql.org/about/donate > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >
