agora inbox for pgsql-general@postgresql.org  

help / color / mirror / Atom feed

From: rob stone <floriparob@tpg.com.au>
To: Adrian Klaver <adrian.klaver@aklaver.com>
To: Alban Hertroys <haramrae@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Multiple schemas
Date: Fri, 25 Sep 2026 16:48:09 +1000
Message-ID: <8b48713a05cbcd6d4d2a4ad5000ae4e09e0fd97d.camel@tpg.com.au> (raw)
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>

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@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
> 
> 

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

Cheers,
Rob

view thread (7+ messages)

Message-ID: <8b48713a05cbcd6d4d2a4ad5000ae4e09e0fd97d.camel@tpg.com.au>
Permalink:  ../8b48713a05cbcd6d4d2a4ad5000ae4e09e0fd97d.camel@tpg.com.au/
Also on:    postgresql.org/message-id/8b48713a05cbcd6d4d2a4ad5000ae4e09e0fd97d.camel@tpg.com.au

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: floriparob@tpg.com.au, adrian.klaver@aklaver.com, haramrae@gmail.com
  Subject: Re: Multiple schemas
  In-Reply-To: <8b48713a05cbcd6d4d2a4ad5000ae4e09e0fd97d.camel@tpg.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox