Re: table.column in query results?

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