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

On 2009-07-22, Andrew Klaassen <clawsoon@yahoo.com> wrote:

Hi,

Is it possible to get table.column in query results rather than just column?

it is possible to get the OID of the table from libpq.
I don't think psql provides display of the table name as a
formatting option, and most wrapper around libpq seem to
ignore this feature.

if you can manipulate the query you can alias the column in
the query and hope that none of the tables or columns has a
dot in its name already!

--- 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/