> On Jan 9, 2021, at 06:22, Markhof, Ingolf <ingolf.markhof@de.verizon.com> wrote:
> What I would like to have is something that would automatically update the SQL code in the software repository when I
runa CREATE OR REPLACE VIEW.
I think you are approaching this backwards. The SQL in the repository should be the definitive version. If you wish
tochange the view, you change the CREATE OR REPLACE VIEW command that you have stored in the repository, and then apply
thatto the database so it now has the new view definition.
You may not, in a small independent project, feel the need for a source code repository, but it becomes very useful
veryquickly.
--
-- Christophe Pettus
xof@thebuild.com