> On Jul 5, 2022, at 11:12, Bryn Llewellyn <bryn@xxxxxxxxxxxx> 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=#
