knowing which table/schema is going to be chosen

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема knowing which table/schema is going to be chosen
Дата
Msg-id 20091112091343.23fe5d0e@dawn.webthatworks.it
обсуждение исходный текст
Ответы Re: knowing which table/schema is going to be chosen
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: pgfoundry new?
Следующее
От: Dave Page
Дата:
Сообщение: Re: [pgeu-general] pgday.eu