Re: Tool to ease development of plpgsql

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>, Richard Huxton <dev(at)archonet(dot)com>
Cc: bill(at)mcmilleon(dot)com, bill(dot)postgresql-users(at)mcmilleon(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Tool to ease development of plpgsql
Date: 2004-01-19 19:14:42
Message-ID: 200401191414.42673.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday 18 January 2004 16:02, D. Dante Lorenso wrote:
> Richard Huxton wrote:
> >On Friday 16 January 2004 22:52, bill(dot)postgresql-users(at)mcmilleon(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-01-19 19:27:04 Re: Integer ranges in PostgreSQL
Previous Message Joshua D. Drake 2004-01-19 19:03:00 Re: New PostgreSQL search resource