"Gurjeet Singh" <[EMAIL PROTECTED]> writes: > I don't think Cristiano is asking for the schema_name in the > EXPLAIN o/p. The request is for the table ALIASes to be shown in the > o/p, which makes more sense than schema_name+table_name, since the > same table can be used in the same query more than once.
But EXPLAIN has always shown the aliases. Possibly a reasonable compromise would be for EXPLAIN to act like rule reverse-listing does, that is, consult the schema search path and print a qualified name only if the table wouldn't be found without it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly