"Scott Miller" <smiller@xxxxxxxxx> 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
