This seems like a relatively straightforward thing to do in pl/perl,
though I don't have time to write code right now. Also, I think this
could be done easily with pl/R, as R has a transpose command. Of
course, if you want to store it back into the database, there will be
some table creation issues.
However, how big is your table? How many times are you going to do
this operation? Could this be done on the client side or even use
Excel or something like that to do the transpose?
Sean
On Feb 24, 2005, at 12:54 AM, ravi shankar wrote:
> HI all...This is very urgent ......How cab I transpose a table in
> postgresql...does it have any buit in SQl feature or functions ...Plz
> help in this regard....
> Regards
> Ravi Shankar
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly