View definition formatting - Mailing list pgsql-hackers

From Dave Page
Subject View definition formatting
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B885FB@mail.vale-housing.co.uk
Whole thread Raw
Responses Re: View definition formatting  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: PostgreSQL and SOAP, suggestions?
Next
From: Jan Wieck
Date:
Subject: Re: View definition formatting