On Wed, Feb 7, 2018 at 11:01 AM, Ted Jones <ted@mentra.co.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).