django-postgres-extra icon indicating copy to clipboard operation
django-postgres-extra copied to clipboard

Add an AlterViewModel and AlterMaterializedViewModel as available operations

Open zschumacher opened this issue 2 years ago • 2 comments

It would be amazing that when I change a query on a PostgresViewModel or PostgresMaterializedViewModel, if psqlextra would generate an alter view migration for me. Currently, I have to either do a SeperateDatabaseAndState to alter the view, or manually add a delete and create view operation to a migration.

zschumacher avatar Nov 12 '21 18:11 zschumacher

Realizing that Postgres doesn't have an alter view mechanism for modifying the query, but auto dropping and creating the view would be nice!

zschumacher avatar Nov 12 '21 20:11 zschumacher