Re: Multiple schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: Multiple schemas
Date
Msg-id 1667964.1790259356@sss.pgh.pa.us
Whole thread
In response to Re: Multiple schemas  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Rob Sargent <robjsargent@gmail.com> writes:
> On Sep 24, 2026, at 10:25 AM, rob stone <floriparob@tpg.com.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



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Multiple schemas
Next
From: Justin
Date:
Subject: Re: Multiple schemas