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" ... Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
