Re: table.column in query results? - Mailing list pgsql-general

--- On Thu, 7/23/09, Albe Laurenz <laurenz.albe@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/