Re: Multiple schemas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: rob stone <floriparob(at)tpg(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple schemas
Date: 2026-09-24 14:15:56
Message-ID: 1667964.1790259356@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rob Sargent <robjsargent(at)gmail(dot)com> writes:
> On Sep 24, 2026, at 10:25 AM, rob stone <floriparob(at)tpg(dot)com(dot)au> wrote:
>> Then I ran:-
>> \d system_defaults (one of the newly created tables)
>> and this was the result:-
>> Did not find any relation named "system_defaults".

> \d bsmdl.system_defaults
> Or
> \dt bsmdl.*

Or perhaps more usefully,

\d *.system_defaults

since this table is evidently not in Rob's search path.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin 2026-09-24 14:17:19 Re: Multiple schemas
Previous Message Rob Sargent 2026-09-24 10:41:51 Re: Multiple schemas