--- On Thu, 7/23/09, Albe Laurenz <laurenz.albe@xxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
