Re: [patch] Proposal for \rotate in psql - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: [patch] Proposal for \rotate in psql
Date
Msg-id 0ab9448b-5553-4201-9595-dd1ba16ed408@mm
Whole thread Raw
In response to [patch] Proposal for \rotate in psql  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: [patch] Proposal for \rotate in psql  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
  Hi,

This is the 2nd iteration of this patch, for comments and review.

Changes:

- the arguments can be column names (rather than only numbers).

- the horizontal headers are sorted server-side according to their original
  type. DESC order is possible by prefixing the column arg with a minus sign.

- the command is now modelled after \g so it can be used
  in place of  \g

- the title is no longer set by the command, it was getting in the
  way when outputting to data file.

- there's a hard limit on 1600 columns. This is to fail early and clean
  on large resultsets that are not amenable to being rotated.

- includes SGML user doc.

As I don't have plans for further improvements, I'll submit this one
to the open commitfest.

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

Attachment

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Reliance on undefined behaviour in << operator
Next
From: Thomas Munro
Date:
Subject: Re: synchronous_commit = apply