Vim PostgreSQL 9.4 syntax plugin with PL/Python support

• Last Change: 2015-06-08
• URL: https://github.com/spacetekk/pgsql.vim

Supports PostgreSQL version 9.4, highlights most builtin functions. Keywords according to: SQL Key Words.

Installation

• Using Vundle, add to .vimrc:

  Plugin 'spacetekk/pgsql.vim'

• Using Pathogen:

  cd ~/.vim/bundle git clone https://github.com/spacetekk/pgsql.vim.git

Usage

Highlights .pgsql files out of the box. You can add pgsql dictionary to vim completion, with:

set dictionary+=~/.vim/bundle/pgsql.vim/dic/pgsql

PL/Pythonu Support

Use special markers while decalraing plpythonu functions or do statements, etc... Example:

create or replace function plpythonu_version() returns text language plpythonu as $python$
    res = plpy.execute('select * from version()')
    return res[0]['version']
$python$;

Bonus

Some usefull snippts