Re: Preserving view source code

Thomas Kellerer wrote:
> Hello,
>
> when I create a view, e.g.:

> And I later retrieve the view's source using "SELECT definition FROM
> pg_view", the source I supplied has been altered by Postgres.
>
> The formatting has been removed completely and PG actually re-wrote the
> query. For the above example I would get:

> Is there a way to tell PG _not_ to alter my SQL, so I can retrieve the
> same (or at least a very similar) version of the original statement?
>
> For procedures this is already the case, so I wonder why the view code
> is altered that much.

The body of a function is just text, so what you put in is what you get out.

The view definition is presumably in the form of a parse-tree or some
such, so what you get back is a human-readable form of that rather than
what you type at the keyboard.

It's the same with pg_dump's interpretation of your table definitions -
you don't get the formatting nor even the "shape" of your definition I'm
afraid.

What are you trying to do that requires the original definition?

--
Richard Huxton
Archonet Ltd