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 <[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 > >
Thanks Adrian. That was the problem -- putting single quotes around the schema names. Now it is working as intended. Cheers, Rob
