Feedback-ID: i76984098:Fastmail
Message-ID: <e1083e9d-ffb2-492f-a204-44ddc1a6ce7d@aklaver.com>
Date: Thu, 24 Sep 2026 08:01:26 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Multiple schemas
To: Alban Hertroys <haramrae@gmail.com>, rob stone <floriparob@tpg.com.au>
Cc: pgsql-general@postgresql.org
References: <12e2ffff149842d8762774e8ef307743cdb96736.camel@tpg.com.au>
 <E874153D-C888-4941-9EF5-A151DFCE6E28@gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <E874153D-C888-4941-9EF5-A151DFCE6E28@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/e1083e9d-ffb2-492f-a204-44ddc1a6ce7d%40aklaver.com>
Precedence: bulk

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