2015-11-05 7:39 GMT+01:00 Craig Ringer <cr...@2ndquadrant.com>: > On 5 November 2015 at 05:22, Pavel Stehule <pavel.steh...@gmail.com> > wrote: > > > If I understand to text on wiki, the name is used for tool, that can do > > little bit more things, but it is often used for this technique (so it is > > much better than "rotate"). I don't understand well, why "crosstab" is > too > > wrong name. This is pretty similar to COPY - and I know, so in first > minutes > > hard to explain this difference between COPY and \copy to beginners, but > > after day of using there is not any problem. > > I see constant confusion between \copy and COPY. It's a really good > reason NOT to overload other psql commands IMO. >
but crosstab is one old function from old extension with unfriendly design. When we support PIVOT/UNPIVOT - the crosstab function will be obsolete. It is not often used command. Regards Pavel > > -- > Craig Ringer http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services >
