I may have several tables with the same name in different schema.
pina.mytable, test.mytable, import.mytable
I have a search_path that may not just consist of $user, public.
eg.
$user, public, test, import
I'd like to know which table is going to be chosen if I do a
select * from mytable;
In this case test.mytable will be chosen.
Is there a way to ask postgresql the schema of the table that will be
chosen?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it