dynamic columns in a query - Mailing list 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