View definition formatting

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: View definition formatting
Date: 2003-04-01 12:34:38
Message-ID: 03AF4E498C591348A42FC93DEA9661B885FB@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers 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.

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2003-04-01 12:35:24 FW: View definition formatting
Previous Message Dave Page 2003-04-01 12:23:50 Re: pgadmin3 query tools

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2003-04-01 13:11:54 Re: View definition formatting
Previous Message mlw 2003-04-01 12:29:51 Re: PostgreSQL and SOAP, suggestions?