--- On Thu, 7/23/09, Albe Laurenz <laurenz.a...@wien.gv.at> wrote: > Andrew Klaassen wrote: > > 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 > > ---+------+----+----- > > ... > > You'd have to use aliases, like > > SELECT id AS "foo.id" ...
Ah... so no way to do it with a wildcard in the query? That's unfortunate. Thanks. Andrew __________________________________________________________________ The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general