by tgl@[EMAIL PROTECTED]
(Tom Lane)
May 3, 2008 at 03:49 PM
"Scott Miller" <smiller@[EMAIL PROTECTED]
> writes:
> One problem I've had in development recently is the inability to get the
> aliased name of a table from a query. We're using a PHP framework for
> querying, which internally uses pg_field_name to retrieve the select
list
> field name, which is great. There is alwo pg_table_name, to retrieve
the
> table the field originated from. The problem is that this returns the
name
> of the table, unaliased. If a query does a self join, you can't
retrieve a
> distingui****ng table alias name for that field.
Sup****ting this would require a protocol change (to allow an additional
field in the result description message). So don't hold your breath :-(
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general