Re: Ways to aggregate table info from variable number of schemas

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Dominique Devienne <ddevienne(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Ways to aggregate table info from variable number of schemas
Date: 2023-11-27 18:21:08
Message-ID: 62A38D12-9706-4EB5-B3C8-79EA50F1693A@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Nov 27, 2023, at 10:16, Dominique Devienne <ddevienne(at)gmail(dot)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 have the appropriate permissions on them). Or do you mean this is a limitation of your system, because of how the permissions are granted?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2023-11-27 18:58:13 Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
Previous Message Dominique Devienne 2023-11-27 18:16:01 Ways to aggregate table info from variable number of schemas