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

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Ways to aggregate table info from variable number of schemas
Дата
Msg-id 62A38D12-9706-4EB5-B3C8-79EA50F1693A@thebuild.com
обсуждение исходный текст
Ответ на Ways to aggregate table info from variable number of schemas  (Dominique Devienne <ddevienne@gmail.com>)
Список pgsql-general
Дерево обсуждения 

> 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 по дате отправления:

Предыдущее
От: Dominique Devienne
Дата:
Сообщение: Ways to aggregate table info from variable number of schemas
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.