Re: references/tutorial/tricks on dynamic generation of sql (& plpgsql functions) editing/coding

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: references/tutorial/tricks on dynamic generation of sql (& plpgsql functions) editing/coding
Date: 2006-09-11 13:36:28
Message-ID: 856BEC43-39D7-468B-A78B-5B6B822A81E0@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Sep 11, 2006, at 8:34 AM, Ivan Sergio Borgonovo wrote:

> Since the code inside the function is getting a bit longer than
> what I was used I'm getting crazy about double quotes, syntax
> highlight and such.
> I'm using pg 7.4 so $$ trick shouldn't work.

If you can't update to 8.0 or later, you might want to look at
pgEdit. It can correctly syntax highlight pl/pgsql functions with
nested quotes.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-09-11 14:09:26 Re: Certificate, login & php question ? krb / sso
Previous Message Purusothaman A 2006-09-11 13:30:00 Re: [GENERAL] Problem with lo_export() and lo_import() from remote machine.