ANN: PostgreSQL syntax mode for Vim

Started by Joel Burtonover 22 years ago2 messagesgeneral
Jump to latest
#1Joel Burton
joel@joelburton.com

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.

Attachments:

pgsql.vimtext/plain; charset=ISO-8859-1; name=pgsql.vimDownload
#2Michael Garriss
mgarriss@earthlink.net
In reply to: Joel Burton (#1)
Re: ANN: PostgreSQL syntax mode for Vim

Very nice! Thank you for your work. I'll be using this soon.

Michael Garriss