table.column in query results?

[Andrew Klaassen <clawsoon@xxxxxxxxx>]

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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general