Re: describe working as intended? - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Re: describe working as intended?
Date
Msg-id 9206511558167466@iva1-80ce53b21b01.qloud-c.yandex.net
Whole thread Raw
In response to describe working as intended?  (Melanie Plageman <melanieplageman@gmail.com>)
Responses Re: describe working as intended?
List pgsql-hackers
Hello

No, this is not bug. This is expected beharior of search_path setting:
https://www.postgresql.org/docs/current/runtime-config-client.html

> Likewise, the current session's temporary-table schema, pg_temp_nnn, is always searched if it exists. It can be
explicitlylisted in the path by using the alias pg_temp. If it is not listed in the path then it is searched first
 

psql \d command checks current search_path (by pg_table_is_visible call). You can use \d *.t1 syntax to display tables
withsuch name in all schemas.
 

regards, Sergei



pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: pglz performance
Next
From: Dean Rasheed
Date:
Subject: Re: Multivariate MCV stats can leak data to unprivileged users