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 E7F5B527-BBA1-4D13-9891-F7B7F1842CE6@thebuild.com
Whole thread Raw
In response to How to keep format of views source code as entered?  ("Markhof, Ingolf" <ingolf.markhof@de.verizon.com>)
List pgsql-general
Tree view 

> On Jan 7, 2021, at 08:19, Markhof, Ingolf <ingolf.markhof@de.verizon.com> wrote:
> I want the SLQ code of my views stored as I entered it. Is there any way to achieve this? Or will I be forced to
maintainmy views SQL code outside of PostgreSQL views? 

The text that you get back from the PostgreSQL system catalogs is based on the parsed version of the view definition,
ratherthan the literal text you entered.  Generally, you maintain your view definition separately in a source code
controlsystem in its original form. 

--
-- Christophe Pettus
   xof@thebuild.com

pgsql-general by date:

Previous
From: "Markhof, Ingolf"
Date:
Subject: How to keep format of views source code as entered?
Next
From: Tom Lane
Date:
Subject: Re: How to keep format of views source code as entered?