Re: table.column in query results?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: table.column in query results?
Date: 2009-07-23 11:28:56
Message-ID: h49hho$4ko$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2009-07-22, Andrew Klaassen <clawsoon(at)yahoo(dot)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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Gon 2009-07-23 11:38:23 ERROR: unexpected data beyond EOF in block of relation "RelationName"
Previous Message Jasen Betts 2009-07-23 11:12:03 Re: Server Backup: pg_dump vs pg_dumpall