Postgres Pro
Downloads
Home   >   mailing lists

Variable column name - Mailing list pgsql-general

From Bob Pawley
Subject Variable column name
Date
Msg-id A35B74CF2573453D89E0AB36E4A56721@BobPC
Whole thread Raw
Responses Re: Variable column name
List pgsql-general
Tree view
Hi
 
I want to add information to multiple columns (20 – 40) by employing a loop. Each pass of the loop will populate one column with an array.
 
I have tried and I have read that variables can not be used to control column names.
 
Is there a means of working around this restriction other than creating 20 to 40 hard coded statements??
 
Bob
 
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Memory leak somewhere at PQconnectdb?
Next
From: Bill Moran
Date:
Subject: Re: Variable column name