Обсуждение: Preserving formatting and comments in a VIEW definition

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?

Robert James <srobertjames@gmail.com> writes:
> 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?

The usual suggestion is to keep your SQL code in an SCM repo, somewhere
outside the database.  Postgres itself saves views as parse trees, so
there's no way it will ever remember whitespace or comments.

            regards, tom lane