Re: Preserving view source code

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Preserving view source code
Date: 2007-10-16 21:39:19
Message-ID: 47152F87.3000005@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 16/10/2007 18:16, Thomas Kellerer wrote:
> I'm maintaining a cross-platform SQL tool that also displays source code
> for views, triggers etc. It would have been nice if the tool could
> actually display the source the same way it looked when the user ran the
> CREATE VIEW statement (which is possible with most of the other DBMS I
> support).

What pgAdmin does is very similar to this, and it produces fairly
well-formatted SQL, if not what was entered originally - it may be worth
your while digging through the pgAdmin code.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2007-10-16 21:42:10 Re: improvement proposition
Previous Message jooy 2007-10-16 21:06:41 Re: need help with rebuilding postgresql