Preserving formatting and comments in a VIEW definition

From: Robert James <srobertjames(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Preserving formatting and comments in a VIEW definition
Date: 2015-03-15 16:35:04
Message-ID: CAGYyBgh_pvb58VK_ovDE_aHRty_aibqet+QBSn9PcBe6PyW4Gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When I save a VIEW, Postgres seems to convert it to a different
format, functionally equivalent but unrecognizable (whitespace,
comments, adds lots of casts, etc.)

Is there any simple way to preserve my original code?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-03-15 16:51:43 Re: Preserving formatting and comments in a VIEW definition
Previous Message David G. Johnston 2015-03-15 16:10:07 Re: How do I calculate the sum of a field filtered by multiple windows defined by another field?