Re: external editor for psql - Mailing list pgsql-general

From Reg Me Please
Subject Re: external editor for psql
Date
Msg-id 200711061651.22789.regmeplease@gmail.com
Whole thread Raw
In response to external editor for psql  ("John Smith" <jayzee.smith@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: How does the query planner make its plan?
Next
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: Postgresql simple query performance question