Search Postgresql Archives

Re: How to keep format of views source code as entered?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Ingolf,

For comments in views, I create a unused CTE and put my comments there, e.g.

WITH v_comments AS (
         SELECT 'this is my comment' AS comment
        )

Alex


Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, January 7, 2021 11:19 AM, Markhof, Ingolf <ingolf.markhof@xxxxxxxxxxxxxx> wrote:

Hi!

 

Switching from Oracle SLQ to PostgreSQL I am facing the issue that the SQL code the system returns when I open a views source code is different from the code I entered. The code is formatted differently, comments are gone and e.g. all text constants got an explicit cast to ::text added. (see sample below).

 

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 maintain my views SQL code outside of PostgreSQL views?

 

Any hints welcome!

 

Here is an example:

 

I enter this code to define a simple view:

 

create or replace view myview as

select

  product_id,

  product_acronym

from

  products -- my comment here

where

  product_acronym = 'ABC'

;

 

However, when I open the view my SQL client (DBeaver) again, this is what I get:

 

CREATE OR REPLACE VIEW myview

AS SELECT product_id,

    product_acronym

   FROM products

  WHERE product_acronym = 'ABC'::text;

 

So, the formatting changed, keywords are capitalized, the comment I added in the from-part has gone and the text constant 'ABC' changed to 'ABC'::text.

 

 

 

 


Verizon Deutschland GmbH - Sebrathweg 20, 44149 Dortmund, Germany - Amtsgericht Dortmund, HRB 14952 - Geschäftsführer: Detlef Eppig - Vorsitzender des Aufsichtsrats: Francesco de Maio



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux