Message-ID: <8b48713a05cbcd6d4d2a4ad5000ae4e09e0fd97d.camel@tpg.com.au>
Subject: Re: Multiple schemas
From: rob stone <floriparob@tpg.com.au>
To: Adrian Klaver <adrian.klaver@aklaver.com>, Alban Hertroys
	 <haramrae@gmail.com>
Cc: pgsql-general@postgresql.org
Date: Fri, 25 Sep 2026 16:48:09 +1000
In-Reply-To: <e1083e9d-ffb2-492f-a204-44ddc1a6ce7d@aklaver.com>
References: <12e2ffff149842d8762774e8ef307743cdb96736.camel@tpg.com.au>
	 <E874153D-C888-4941-9EF5-A151DFCE6E28@gmail.com>
	 <e1083e9d-ffb2-492f-a204-44ddc1a6ce7d@aklaver.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2-10 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/8b48713a05cbcd6d4d2a4ad5000ae4e09e0fd97d.camel%40tpg.com.au>
Precedence: bulk

On Thu, 2026-09-24 at 08:01 -0700, Adrian Klaver wrote:
> On 9/24/26 2:19 AM, Alban Hertroys wrote:
> >=20
> > > On 24 Sep 2026, at 10:24, rob stone <floriparob@tpg.com.au>
> > > wrote:
> > >=20
> > > Hello,
> > >=20
> > > I've been using a single schema in a database for years and I
> > > decided
> > > to try using multiple schemas in the same database.
> > >=20
> > > 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.
> >=20
> > =E2=80=A6
> >=20
> > > show search_path;
> > > =C2=A0 search_path
> > > ----------------
> > > "bsmdl, foots"
> > > (1 row)
> >=20
> > I think there=E2=80=99s your problem. You have schemas named =E2=80=9Cb=
smdl=E2=80=9D and
> > =E2=80=9Cfoots=E2=80=9D, not a schema named "bsmdl, foots=E2=80=9D.
>=20
> In other words you did:
>=20
> SET search_path TO 'bsmdl, foots'
>=20
> and got
>=20
> SHOW search_path ;
> =C2=A0=C2=A0 search_path
> ----------------
> =C2=A0 "bsmdl, foots"
>=20
>=20
> Instead you should do:
>=20
> SET search_path TO bsmdl, foots;
>=20
> to get:
>=20
> SHOW search_path ;
> =C2=A0 search_path
> --------------
> =C2=A0 bsmdl, foots
>=20
>=20

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

Cheers,
Rob