On 9/24/26 2:19 AM, Alban Hertroys wrote:
On 24 Sep 2026, at 10:24, rob stone <[email protected]> wrote:
Hello,
I've been using a single schema in a database for years and I decided
to try using multiple schemas in the same database.
So, I set up a test database and followed the same procedure that I
have used in the past but this time specifying multiple schemas.
…
show search_path;
search_path
----------------
"bsmdl, foots"
(1 row)
I think there’s your problem. You have schemas named “bsmdl” and “foots”, not a
schema named "bsmdl, foots”.
In other words you did:
SET search_path TO 'bsmdl, foots'
and got
SHOW search_path ;
search_path
----------------
"bsmdl, foots"
Instead you should do:
SET search_path TO bsmdl, foots;
to get:
SHOW search_path ;
search_path
--------------
bsmdl, foots
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
--
Adrian Klaver
[email protected]
