Re: Feature request

"Scott Miller" <smiller@duels.com> 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
> distinguishing table alias name for that field.

Supporting 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