Postgres Pro
Downloads
Home   >   mailing lists

Re: How to keep format of views source code as entered? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: How to keep format of views source code as entered?
Date
Msg-id DA92A5B2-3CDA-4EFB-9638-6AAF46040903@thebuild.com
Whole thread Raw
In response to RE: How to keep format of views source code as entered?  ("Markhof, Ingolf" <ingolf.markhof@de.verizon.com>)
List pgsql-general
Tree view 
Hello,

> On Jan 7, 2021, at 09:33, Markhof, Ingolf <ingolf.markhof@de.verizon.com> wrote:
>
> So, it looks like PostgreSQL does support saving the original source code of a view.

To be clear, PostgreSQL itself does not.  The suggestion is to use an external source code repository, such as GitHub,
GitLab,or one of (many!) other tools or products to store the view definition. 

This has benefits besides just retaining the original source code, as you mention below: Version control, tracking,
issuemanagement and commit merging, etc. 
--
-- Christophe Pettus
   xof@thebuild.com

pgsql-general by date:

Previous
From: "Markhof, Ingolf"
Date:
Subject: RE: How to keep format of views source code as entered?
Next
From: Kevin Brannen
Date:
Subject: RE: Is there a good discussion of optimizations?