From: | Alex Williams <valenceshell(at)protonmail(dot)com> |
---|---|
To: | "Markhof, Ingolf" <ingolf(dot)markhof(at)de(dot)verizon(dot)com> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: How to keep format of views source code as entered? |
Date: | 2021-01-12 19:54:22 |
Message-ID: | ZwqaxBS916weX4SzlaECaBjVVtgHynQCALiE9WcwI1JSPyG12aquNuTzCgxwJZgX1Y6yprQZKejb8Nga-kULrMog4chx0a7zu0nP_OIhaeE=@protonmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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](https://protonmail.com) Secure Email.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, January 7, 2021 11:19 AM, Markhof, Ingolf <ingolf(dot)markhof(at)de(dot)verizon(dot)com> 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:
>
> createorreplaceview 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:
>
> CREATEORREPLACEVIEW myview
>
> ASSELECT 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2021-01-12 21:17:36 | Re: How to keep format of views source code as entered? |
Previous Message | Day, David | 2021-01-12 18:23:47 | Views and triggers more then one row returned by subquery. |