Re: Multiple schemas

On Thu, 2026-09-24 at 08:01 -0700, Adrian Klaver wrote:
> 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
>
>

Thanks Adrian.
That was the problem -- putting single quotes around the schema names.
Now it is working as intended.

Cheers,
Rob