pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcolored PL with emacs
7+ messages / 6 participants
[nested] [flat]
* colored PL with emacs
@ 2004-08-31 11:42 Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 12:11 ` Re: colored PL with emacs Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>
0 siblings, 1 reply; 7+ messages in thread
From: Martin Marques @ 2004-08-31 11:42 UTC (permalink / raw)
To: pgsql-sql
Does anyone know of a .el file that can be used with Emacs to get colored
coding when working with PL/pgSQL?
--
08:40:01 up 8 days, 27 min, 1 user, load average: 2.53, 2.09, 1.70
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: colored PL with emacs
2004-08-31 11:42 colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
@ 2004-08-31 12:11 ` Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>
2004-08-31 12:32 ` Re: colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
0 siblings, 1 reply; 7+ messages in thread
From: Stephen Quinney @ 2004-08-31 12:11 UTC (permalink / raw)
To: Martin Marques <martin@bugs.unl.edu.ar>; +Cc: pgsql-sql
On Tue, Aug 31, 2004 at 08:42:44AM -0300, Martin Marques wrote:
> Does anyone know of a .el file that can be used with Emacs to get colored
> coding when working with PL/pgSQL?
>
Emacs 21.3 (and possibly earlier versions) comes with an SQL mode
which I know has a PostgreSQL keyword highlighting option in the
menu. Just just need:
Meta-x sql-mode
Meta-x global-font-lock-mode
(and possibly select the postgres option in the highlighting bit of
the SQL menu that appears if you are using X)
I hope that helps,
Stephen Quinney
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: colored PL with emacs
2004-08-31 11:42 colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 12:11 ` Re: colored PL with emacs Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>
@ 2004-08-31 12:32 ` Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 17:23 ` Re: colored PL with emacs Manuel Sugawara <masm@fciencias.unam.mx>
0 siblings, 1 reply; 7+ messages in thread
From: Martin Marques @ 2004-08-31 12:32 UTC (permalink / raw)
To: Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>; +Cc: pgsql-sql
El Mar 31 Ago 2004 09:11, Stephen Quinney escribió:
> On Tue, Aug 31, 2004 at 08:42:44AM -0300, Martin Marques wrote:
> > Does anyone know of a .el file that can be used with Emacs to get colored
> > coding when working with PL/pgSQL?
>
> Emacs 21.3 (and possibly earlier versions) comes with an SQL mode
> which I know has a PostgreSQL keyword highlighting option in the
> menu. Just just need:
>
> Meta-x sql-mode
> Meta-x global-font-lock-mode
>
> (and possibly select the postgres option in the highlighting bit of
> the SQL menu that appears if you are using X)
I have SQL highlighting, but what I want are colors for the PL/pgSQL key
words. It would make PL programming much easier.
--
09:30:02 up 8 days, 1:17, 2 users, load average: 0.70, 0.44, 0.54
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: colored PL with emacs
2004-08-31 11:42 colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 12:11 ` Re: colored PL with emacs Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>
2004-08-31 12:32 ` Re: colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
@ 2004-08-31 17:23 ` Manuel Sugawara <masm@fciencias.unam.mx>
2004-08-31 22:31 ` Re: colored PL with emacs Josh Berkus <josh@agliodbs.com>
2004-09-01 15:57 ` Re: colored PL with emacs John DeSoi <jd@icx.net>
0 siblings, 2 replies; 7+ messages in thread
From: Manuel Sugawara @ 2004-08-31 17:23 UTC (permalink / raw)
To: Martin Marques <martin@bugs.unl.edu.ar>; +Cc: Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>; pgsql-sql
Martin Marques <martin@bugs.unl.edu.ar> writes:
> I have SQL highlighting, but what I want are colors for the PL/pgSQL
> key words. It would make PL programming much easier.
Since the Pl/PgSQL code is quoted (x)emacs paints the whole thing
using the string face. Delete one of the apostrophes delimiting the
code while editing and you should get some highlighting.
Regards,
Manuel.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: colored PL with emacs
2004-08-31 11:42 colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 12:11 ` Re: colored PL with emacs Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>
2004-08-31 12:32 ` Re: colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 17:23 ` Re: colored PL with emacs Manuel Sugawara <masm@fciencias.unam.mx>
@ 2004-08-31 22:31 ` Josh Berkus <josh@agliodbs.com>
2004-08-31 23:19 ` Re: colored PL with emacs Greg Sabino Mullane <greg@turnstep.com>
1 sibling, 1 reply; 7+ messages in thread
From: Josh Berkus @ 2004-08-31 22:31 UTC (permalink / raw)
To: Manuel Sugawara <masm@fciencias.unam.mx>; +Cc: Martin Marques <martin@bugs.unl.edu.ar>; Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>; pgsql-sql
Martin,
> > I have SQL highlighting, but what I want are colors for the PL/pgSQL
> > key words. It would make PL programming much easier.
KDE's Kate has PostgreSQL highlighting. Unfortunately, the config is XML so
it's not transferrable to Emacs ...
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: colored PL with emacs
2004-08-31 11:42 colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 12:11 ` Re: colored PL with emacs Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>
2004-08-31 12:32 ` Re: colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 17:23 ` Re: colored PL with emacs Manuel Sugawara <masm@fciencias.unam.mx>
2004-08-31 22:31 ` Re: colored PL with emacs Josh Berkus <josh@agliodbs.com>
@ 2004-08-31 23:19 ` Greg Sabino Mullane <greg@turnstep.com>
0 siblings, 0 replies; 7+ messages in thread
From: Greg Sabino Mullane @ 2004-08-31 23:19 UTC (permalink / raw)
To: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> I have SQL highlighting, but what I want are colors for the PL/pgSQL
> key words. It would make PL programming much easier.
There's nothing out there. but writing one is on my long-term TODO list.
> KDE's Kate has PostgreSQL highlighting. Unfortunately, the config
> is XML so it's not transferrable to Emacs ...
Send me (or the list, of it's short) a copy, I'll see if I can
do anything with it.
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200408311920
-----BEGIN PGP SIGNATURE-----
iD8DBQFBNQfgvJuQZxSWSsgRAl8CAJ9bmcZG/pTx9Pg5H+sjxT77RbWsLwCg0b1u
oB/ZJocEC42tdahkIrlBIZs=
=eF8t
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: colored PL with emacs
2004-08-31 11:42 colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 12:11 ` Re: colored PL with emacs Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>
2004-08-31 12:32 ` Re: colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 17:23 ` Re: colored PL with emacs Manuel Sugawara <masm@fciencias.unam.mx>
@ 2004-09-01 15:57 ` John DeSoi <jd@icx.net>
1 sibling, 0 replies; 7+ messages in thread
From: John DeSoi @ 2004-09-01 15:57 UTC (permalink / raw)
To: Manuel Sugawara <masm@fciencias.unam.mx>; +Cc: Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>; Martin Marques <martin@bugs.unl.edu.ar>; pgsql-sql
On Aug 31, 2004, at 1:23 PM, Manuel Sugawara wrote:
>
>> I have SQL highlighting, but what I want are colors for the PL/pgSQL
>> key words. It would make PL programming much easier.
>
> Since the Pl/PgSQL code is quoted (x)emacs paints the whole thing
> using the string face. Delete one of the apostrophes delimiting the
> code while editing and you should get some highlighting.
I'm working on an editor specifically designed for PostgreSQL and
plpgsql programming. It colors syntax within function strings and helps
get the quoting right (8.0 dollar quoting is also supported). The
editor is based on emacs but it also has emulation modes that are more
friendly for those who are not familiar with emacs. I hope to start
beta testing the Mac OS X version next week, followed by a Windows
version probably in October. I have not yet decided if I will do a
Linux version, but it should be possible. The estimated price for this
product is $65.
Send me an email if you are interested in beta testing the Mac OS X
version.
Best,
John DeSoi, Ph.D.
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2004-09-01 15:57 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-31 11:42 colored PL with emacs Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 12:11 ` Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>
2004-08-31 12:32 ` Martin Marques <martin@bugs.unl.edu.ar>
2004-08-31 17:23 ` Manuel Sugawara <masm@fciencias.unam.mx>
2004-08-31 22:31 ` Josh Berkus <josh@agliodbs.com>
2004-08-31 23:19 ` Greg Sabino Mullane <greg@turnstep.com>
2004-09-01 15:57 ` John DeSoi <jd@icx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox