Create a function that will create or substitute a view with criteria stored on tables.
A table will store arrays that will contain view name, column names, data types, etc. Every change on this table will re-create the view.
Would be nice to have sample of the table and the expected view. However I imagine some data and I already made the function you need in PLpgSQL. I have worked several years with PostgreSQL (in my profile you can che Daha Fazla
Bu iş için 7 freelancer ortalamada $159 teklif veriyor
I m DB developer from 4 years and its easy for me to create such table valued function...
Hello . I work as a postgresql DBA and I teach Databases at the university. I can do this Job.