Обсуждение: plpgsql editor(s)?

Поиск
Список
Период
Сортировка

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


Re: plpgsql editor(s)?

От
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.
+40213212243
-----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-----


Re: plpgsql editor(s)?

От
Geoffrey
Дата:
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

vim offers all this functionality.

--
Until later, Geoffrey                     Registered Linux User #108567
Building secure systems in spite of Microsoft

Re: plpgsql editor(s)?

От
Christopher Browne
Дата:
After a long battle with technology, andrew.biagioni@e-greek.net (Andrew Biagioni), an earthling, 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

Building an "electric" mode for Emacs would almost certainly be The
Right Answer.  Nobody has done so yet.
--
"cbbrowne","@","ntlug.org"
http://www.ntlug.org/~cbbrowne/internet.html
Why do we drive on parkways and park on driveways?

Re: plpgsql editor(s)?

От
David Filion
Дата:
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
>

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