On Wed, Feb 7, 2018 at 11:01 AM, Ted Jones <ted(at)mentra(dot)co(dot)uk> wrote:
> Hi Murtuza
>
> Thank you for your reply. Unfortunately it is not practical to use this
> approach when there may be 100s of columns! I will look at pgfutter.
>
When faced with this situation, and feeling unmotivated to go learn a new
tool, I resort to a spreadsheet. You can easily build a CREATE TABLE
statement in the spreadsheet after split-copy-transpose-pasting the header
row (appending "text," to each row's column label is a simply formula).
David J.