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
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 |