Re: Multiple schemas

On 9/24/26 2:19 AM, Alban Hertroys wrote:
>
>> On 24 Sep 2026, at 10:24, rob stone <floriparob(at)tpg(dot)com(dot)au> 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
adrian(dot)klaver(at)aklaver(dot)com