Re: [HACKERS] View definition formatting

2003-04-02 Thread Dave Page
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 01 April 2003 20:59 > To: Robert Treat > Cc: Peter Eisentraut; Dave Page; [EMAIL PROTECTED] > Subject: Re: [HACKERS] View definition formatting > > > We could make variants of pg_get_

Re: [HACKERS] View definition formatting

2003-04-01 Thread Rod Taylor
On Tue, 2003-04-01 at 14:18, Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Perhaps as a workaround you could invent a standard indentation format and > > format the rules automatically that way, so that users will be able to > > find everything in the same place automatically a

Re: [HACKERS] View definition formatting

2003-04-01 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > Dave Page wrote: >> 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? > Not too obvi

[HACKERS] View definition formatting

2003-04-01 Thread Dave Page
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