Re: table.column in query results?

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: table.column in query results?
Дата
Msg-id h49hho$4ko$2@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на table.column in query results?  (Andrew Klaassen <clawsoon@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Server Backup: pg_dump vs pg_dumpall
Следующее
От: Willy-Bas Loos
Дата:
Сообщение: comparing NEW and OLD (any good this way?)