Re: external editor for psql

Il Tuesday 06 November 2007 16:40:27 John Smith ha scritto:
> http://www.nabble.com/need-good-editor-for-postgreSQL-tf3660882.html#a10229
>560
>
> how do u get gvim (portable?) to do syntax color highlighting for
> sql/plpgsql on files in buffer?? you're right- notepad is not enough
> (and pgedit is not free).
>
> cheers, jzs
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

1. I've looked for the PostgreSQL syntax script by Manni Wood.
(I don't remember from where, maybe www.vim.org)

2. I've installed it as /usr/share/vim/vim71/syntax/postgresql.vim

3. I've edited /usr/share/vim/vim71/filetype.vim in order to add
this line:

au BufNewFile,BufRead *.psql                    setf postgresql

Now all .psql files get the Posgres highlighting.

--
Reg me Please