Ooops, forgot to CC it.
> -----Original Message-----
> From: Dave Page
> Sent: 01 April 2003 13:35
> To: pgsql-hackers@postgresql.org
> Subject: View definition formatting
>
>
> Hi all,
>
> When using pg_get_viewdef(oid), the view definition is
> returned in a reconstructed form (I assume) with all
> formatting removed. This is a pain for apps like pgAdmin,
> that allow the user to edit their views, particularly with
> very large ones.
>
> Would it be possible and sensible to store the original view
> definition for future use, such as we do for functions?
> Perhaps a new catalog (pg_source?) could store these and
> other definitions such as rules for use?
>
> Regards, Dave.
>
