Uwe C. Schroeder wrote:
> I wasn't able to get a usable answer by googling: Is there a way to create a 
> view on a table that converts rows to columns ?
[snip]
> Is the above doable with a view?
> Any pointers will be appreciated.

Search the postgresql-sql list archives for "Arbitrary Cross-tab" for 
recent discussion on this.

HTH
-- 
   Richard Huxton
   Archonet Ltd

In response to

• Is it possible... at 2004-08-24 15:47:43 from Uwe C. Schroeder

pgsql-general by date

Next:	From: Tom Lane	Date: 2004-08-24 16:11:00
	Subject: Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
Previous:	From: Joe Conway	Date: 2004-08-24 16:07:42
	Subject: Re: Is it possible...