ANN: PostgreSQL syntax mode for Vim

From: Joel Burton <joel(at)joelburton(dot)com>
To: pgsql-general(at)postgresql(dot)org, vim(at)vim(dot)org
Subject: ANN: PostgreSQL syntax mode for Vim
Date: 2003-08-06 13:33:42
Message-ID: 1060176822.2046.8.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've created a PostgreSQL syntax mode for Vim. This will colorize pgdump
files and hand-crafted SQL files for PostgreSQL.

It is based on, and still similar to, the generic SQL mode for Vim. It
adds many PG-specific keywords, operators, and such.

To use this, copy the file to your $VIMRUNTIME/syntax or personal .vim
syntax directory (in Unix, that's usually $HOME/.vim/syntax; in Windows,
usually c:\vim\vimfiles\syntax). Open a PG file and :set filetype=pgsql.

Two items on the TODO list are:

* Handle functions better. Right now, the entire body of the function is
treated as a string. Would be nice to have it colorized internally.

* Handle psql SET statements better. I'm finding it difficult to
distinguish these from UPDATE.. SET.. statements.

I'd be happy to get any feedback, etc., from anyone. After a round of
feedback and clean-up, I'll find a suitable place to post & maintain it.

Thanks!

- j.

Attachment Content-Type Size
pgsql.vim text/plain 7.2 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Oksfeldt Jonasen 2003-08-06 13:34:36 Error message: Ralation X does not have attribute Y
Previous Message The Hermit Hacker 2003-08-06 13:22:40 v7.4 on Windows ... (Was: Re: v7.4 Beta 1 Bundle ...)