Re: Tool to ease development of plpgsql - Mailing list pgsql-general

From Robert Treat
Subject Re: Tool to ease development of plpgsql
Date
Msg-id 200401191414.42673.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: Tool to ease development of plpgsql  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
On Sunday 18 January 2004 16:02, D. Dante Lorenso wrote:
> Richard Huxton wrote:
> >On Friday 16 January 2004 22:52, bill.postgresql-users@mcmilleon.com wrote:
> >>What's the best way to ease development of plpgsql.
> >>My largest issues with plpgsql pertain to the quoting of course.
> >
> >3. To work around the EXPLAIN problem I copy/paste SQL from my function,
> > at which time I have to unfix the quoting, then paste it back and refix
> > the quoting...
>
> <plug>
>
> I use EMS PostgreSQL Manager to edit PL/PGSQL functions.  It automagically
> escapes the quotes for you as you write functions, so you can just write:
>
>     SELECT 'sometexthere'::text;
>
> instead of having to do:
>
>     SELECT ''sometexthere''::text;
>
> It's a major time saver when developing.  You gotta pay money for PG
> Manager,
> but it's worth it and has Windows and Linux versions.
>
>     http://www.ems-hitech.com/pgmanager/download.phtml
>
> </plug>
>

FWIW I believe both phpPgAdmin and PgAdmin do this.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [pgsql-advocacy] New PostgreSQL search resource
Next
From: Stephan Szabo
Date:
Subject: Re: Integer ranges in PostgreSQL