Postgresql syntax from Devrim GUNDUZ
Vim script
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.

Vim Postgresql syntax file


If you use Pathogen for plugin management, simply clone this repository into ~/.vim/bundle to make the pgsql syntax type available:

git clone ~/.vim/bundle/pgsql.vim

If you prefer to install manually, copy syntax/pgsql.vim into your ~/.vim/syntax/ directory, creating it if necessary.


Files with the suffix .pgsql will use the pgsql highlighting automatically.

To enable pgsql syntax for any open buffer, use:

:set syntax=pgsql

Enabling for all .sql files

You can make pgsql.vim the default for SQL syntax by adding this line to your .vimrc:

let g:sql_type_default = 'pgsql'

This tells the sql.vim module to use the pgsql dialect.

Alternately, you can use an autocmd in your ~/.vim/filetype.vim to enable it for all .sql files or some finer pattern:

autocmd BufNewFile,BufRead *.sql setf pgsql

You do not need both. If in doubt, use the first method.