kristiandupont/extract-pg-schema

TODO

kristiandupont opened this issue · 2 comments

Issues that I want to add:

  • ❌ BUG: duplicate columns reported when a column has multiple foreign key constraints
  • Routine support (procedures, functions, aggregates)
  • Class: index
  • Class: sequence
  • Information about row-level security policies added to tables (what about views?)
  • Experiment with https://github.com/electric-sql/pglite instead of test-containers

I would really love to have (non catalog) functions listed

I'm working on a pg query gen tool and this is the next step, along with using RLS to refine what to generate

Are there any known blockers?

Yeah, I have been wanting to do that for a long time (as you can see!)
The only blocker is my lack of time :-) I will get around to it at some point but I can't make any promises as to when.