Search Postgresql Archives

Re: Strange "missing tables" problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello Tom,

Tom Lane a écrit :
> Denis BUCHER <dbucherml@xxxxxxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux