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

From Jasen Betts
Subject Re: table.column in query results?
Date
Msg-id h49hho$4ko$2@reversiblemaps.ath.cx
Whole thread Raw
In response to table.column in query results?  (Andrew Klaassen <clawsoon@yahoo.com>)
List pgsql-general
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!


pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Server Backup: pg_dump vs pg_dumpall
Next
From: Willy-Bas Loos
Date:
Subject: comparing NEW and OLD (any good this way?)