On Wed, Feb 7, 2018 at 11:01 AM, Ted Jones <t...@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). David J.