Re: Strange "missing tables" problem

Поиск
Список
Период
Сортировка
От Denis BUCHER
Тема Re: Strange "missing tables" problem
Дата
Msg-id 4A924CDF.3080101@hsolutions.ch
обсуждение исходный текст
Ответ на Re: Strange "missing tables" problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello Tom,

Tom Lane a écrit :
> Denis BUCHER <dbucherml@hsolutions.ch> writes:
>> I really don't understand what's happening here ?
>
> "\dt customers" will show you the customers table that's visible
> according to your search_path setting.  Apparently schema "import"
> is either not in your search path at all, or behind "rma".

It is in the search path.

Do you mean that \dt customers shows only the FIRST "customers" table
found ?

If yes, that's a part of the explanation, BUT :
If I do \dt (without specifying a table name), does it lists only ONE
table of each name, and only the one in the first schema present in the
search path.

Denis


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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Install from Source On Windows - University of Sydney Research
Следующее
От: Denis BUCHER
Дата:
Сообщение: Re: Strange "missing tables" problem