Aliasing all fields - Mailing list pgsql-general

Is there a way to get PostgreSQL to alias all fields in a select even if
there is no naming conflict?  For instance, if I do a:

select * from table1, table2 where table1.t1c1 = table2.t2c2

then I want

table1.t1c1 | table1.t1c2 | table1.t1c3 | table2.t2c1 | table2.t2c2

Not just the column names.

Thanks,
Rob Hutton
Web Safe
www.wsafe.com