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

2023-11-27 Thread Christophe Pettus
> On Nov 27, 2023, at 10:16, Dominique Devienne 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 acc

Ways to aggregate table info from variable number of schemas

2023-11-27 Thread Dominique Devienne
Our PostgreSQL-based system uses a small number of fixed schemas, and an arbitrary number of per-project schemas (one schema per project). This will is given, sorry, cannot be changed. Really. The fixed schemas contain metadata about the projects (including which schema a given project uses). My