Postgres Pro
Downloads
Home   >   mailing lists

Re: Ways to aggregate table info from variable number of schemas - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Ways to aggregate table info from variable number of schemas
Date
Msg-id 62A38D12-9706-4EB5-B3C8-79EA50F1693A@thebuild.com
Whole thread Raw
In response to Ways to aggregate table info from variable number of schemas  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view 

> On Nov 27, 2023, at 10:16, Dominique Devienne <ddevienne@gmail.com> wrote:
> Which means you can't do a declarative SQL query for those
> metadata across projects, since you can't do static / non-dynamic SQL across schemas.

I'm not sure I understand this.  Schemas are just namespaces, and all queries have access to them (assuming their roles
havethe appropriate permissions on them).  Or do you mean this is a limitation of your system, because of how the
permissionsare granted?

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Ways to aggregate table info from variable number of schemas
Next
From: Laurenz Albe
Date:
Subject: Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.