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

From Andrew Klaassen
Subject table.column in query results?
Date
Msg-id 126600.21837.qm@web65414.mail.ac4.yahoo.com
Whole thread Raw
Responses Re: table.column in query results?
List pgsql-general
Hi,

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
---+------+----+-----
...

Thanks.

Andrew




      __________________________________________________________________
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now
http://ca.toolbar.yahoo.com.

pgsql-general by date:

Previous
From: Andreas Wenk
Date:
Subject: Re: psql \du [PATCH] extended \du with [+] - was missing
Next
From: Jeremy Brown
Date:
Subject: Select Column Auditing/Logging