Re: describe working as intended?

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Melanie Plageman <melanieplageman(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: describe working as intended?
Date: 2019-05-18 08:17:46
Message-ID: 9206511558167466@iva1-80ce53b21b01.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 explicitly listed 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 with such name in all schemas.

regards, Sergei

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2019-05-18 09:11:58 Re: Multivariate MCV stats can leak data to unprivileged users
Previous Message Magnus Hagander 2019-05-18 08:13:17 Re: PostgreSQL 12: Feature Highlights