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
