plpgsql editor(s)?

[Andrew Biagioni]

Can anyone recommend an editor (windows OR linux) for writing plpgsql
code, that might be friendlier than a standard text editor?

Nice features I can think of might be:
- smart tabbing (1 tab = N spaces)
- code coloring (esp. quoted strings!)
- parens/brackets matching

Thanks,

Andrew


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Christopher Browne]

Post by Andrew Biagioni
Can anyone recommend an editor (windows OR linux) for writing plpgsql
code, that might be friendlier than a standard text editor?
- smart tabbing (1 tab = N spaces)
- code coloring (esp. quoted strings!)
- parens/brackets matching

Building an "electric" mode for Emacs would almost certainly be The
Right Answer. Nobody has done so yet.

[Radu-Adrian Popescu]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andrew Biagioni wrote:
| Can anyone recommend an editor (windows OR linux) for writing plpgsql
| code, that might be friendlier than a standard text editor?
|
| Nice features I can think of might be:
| - smart tabbing (1 tab = N spaces)
| - code coloring (esp. quoted strings!)
| - parens/brackets matching
|
| Thanks,
|
| Andrew
|
|
| ---------------------------(end of broadcast)---------------------------
| TIP 9: the planner will ignore your desire to choose an index scan if your
| joining column's datatypes do not match
|
|

Hi Andrew,

You might want to try nedit - pretty light and highly customisable, X11/Motif,
regexp & syntax colouring.

If you do come up with a proper plpgsql colourisation scheme, do share it :-) !

Cheers,
- --
Radu-Adrian Popescu
CSA, DBA, Developer
Aldratech Ltd.
[phone]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFAbWgDVZmwYru5w6ERAoN+AJ40OdRxmGnglc2EvO2fViBQU0p+qwCeLFFb
TfbZRSAoo5Xk6U8OyVod+40=
=2L87
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Geoffrey]

Post by Andrew Biagioni
Can anyone recommend an editor (windows OR linux) for writing plpgsql
code, that might be friendlier than a standard text editor?
- smart tabbing (1 tab = N spaces)
- code coloring (esp. quoted strings!)
- parens/brackets matching

vim offers all this functionality.

[David Filion]

Post by Andrew Biagioni
Can anyone recommend an editor (windows OR linux) for writing plpgsql
code, that might be friendlier than a standard text editor?
- smart tabbing (1 tab = N spaces)
- code coloring (esp. quoted strings!)
- parens/brackets matching
Thanks,
Andrew
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

UltraEdit, www.ultraedit.com. It's a win32 app but is does have built in
FTP/SFTP support for tranfering to/from servers. It also supports
unix<->DOS formatting along with utf-8.

It may work under wine, I haven't tried it though.

David Filion