table.column in query results?

Hi,

Is it possible to get table.column in query results rather than just column?

I.e. I'd like:

SELECT * FROM foo, bar;
foo.id | foo.name | bar.id | bar.text
-------+----------+--------+---------
...

...rather than:

SELECT * FROM foo, bar;
id | name | id | text
---+------+----+-----
...

Thanks.

Andrew




      __________________________________________________________________
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now
http://ca.toolbar.yahoo.com.