Thread: external editor for psql

http://www.nabble.com/need-good-editor-for-postgreSQL-tf3660882.html#a10229560

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

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

On 11/6/07, John Smith <jayzee.smith@gmail.com> wrote:
> http://www.nabble.com/need-good-editor-for-postgreSQL-tf3660882.html#a10229560
>
> 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).

Don't know about gvim but vim automagicall does it for files that end in .sql

I also use Gedit a lot on my workstation and it does color
highlighting of .sql files as well.