Re: Seems to be impossible to set a NULL search_path - Mailing list pgsql-general

> On Jul 5, 2022, at 11:12, Bryn Llewellyn <bryn@yugabyte.com> wrote:
> Finally, what do you think of a possible future enhancement to allow setting a null search_path?

You use the empty string, rather than NULL, but it works right now:

xof=# show search_path;
   search_path
-----------------
 "$user", public
(1 row)

xof=# select * from t;
 i | d1 | d2
---+----+----
(0 rows)

xof=# set search_path='';
SET
xof=# show search_path;
 search_path
-------------
 ""
(1 row)

xof=# select * from t;
ERROR:  relation "t" does not exist
LINE 1: select * from t;
                      ^
xof=#