Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> On Nov 27, 2023, at 10:16, Dominique Devienne <ddevienne@xxxxxxxxx> 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?





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux