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