dynamic columns in a query

From: "Jyoti Seth" <jyotiseth2001(at)gmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: dynamic columns in a query
Date: 2009-06-11 07:42:06
Message-ID: 000001c9ea68$217cb890$647629b0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

Is there any way in postgres to write a query to display the result in
matrix form. (where column names are dynamic)

For eg.

Employee Name Client1 Client2 Client3 Client4
Emp1 100 102 90 23
Emp2 56 0 23 98
Emp3 34 45 76 0

Here Client1, Client2... are the values from the database.

Thanks,
Jyoti

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2009-06-11 07:53:41 Re: dynamic columns in a query
Previous Message A. Kretschmer 2009-06-11 07:31:06 Re: Avoiding "will create implicit index" NOTICE