Re: How are the SELECT queries reconstructed in pg_views

2023-03-28 Thread Adrian Klaver
On 3/28/23 13:23, Adrian Klaver wrote: On 3/28/23 06:43, Julius de Bruijn wrote: Hi, I haven't been able to find exactly what changes PostgreSQL does when reconstructing the query, but I've successfully been able to create views where the resulting query differs from what I wrote. Is there an

Re: How are the SELECT queries reconstructed in pg_views

2023-03-28 Thread Adrian Klaver
On 3/28/23 06:43, Julius de Bruijn wrote: Hi, We at Prisma are implementing developer tooling for PostgreSQL database amongst the others. One part of our tooling is the migration of schema changes to the database. We do that by diffing the schema from the file system against the one we introspec

How are the SELECT queries reconstructed in pg_views

2023-03-28 Thread Julius de Bruijn
Hi, We at Prisma are implementing developer tooling for PostgreSQL database amongst the others. One part of our tooling is the migration of schema changes to the database. We do that by diffing the schema from the file system against the one we introspect from the database; storing the changes to