sponsor Vim development Vim logo Vim Book Ad

pgsql : The best PostgreSQL plugin for Vim!

 script karma  Rating 1/3, Downloaded by 2924  Comments, bugs, improvements  Vim wiki

created by
script type
This plugin provides syntax highlighting and auto-completion support for PostgreSQL and for some of its extensions, including PL/pgSQL, PostGIS, pgTap, and many others. Integrates with Vim built-in support for SQL rather than reinventing the wheel. Supports embedded syntax highlighting for any language inside SQL user-defined functions.

Source code available on GitHub: https://github.com/lifepillar/pgsql.vim
install details
If your Vim supports packages (echo has('packages') prints 1), I strongly recommend that you use them. Just clone this repo inside pack/*/start, e.g.,

  cd ~/.vim
  git clone https://github.com/lifepillar/pgsql.vim.git pack/bundle/start/pgsql

Otherwise, if you don't have a preferred installation method, I recommend installing Pathogen, and then simply copy and paste:

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

rate this script Life Changing Helpful Unfulfilling 
script versions (upload new version)

Click on the package to download.

package script version date Vim version user release notes
pgsql.vim-2.3.0.tar.gz 2.3.0 2020-11-16 7.4 Lifepillar Upgrade for PostgreSQL 13.0. License under Vim license.
pgsql.vim-2.1.2.tar.gz 2.1.2 2018-08-05 7.0 Lifepillar Do not treat backslash as escape char in strings and identifiers. Update tests.
pgsql.vim-2.1.1.tar.gz 2.1.1 2018-05-20 7.0 Lifepillar Updated for PostgreSQL 10.4.
pgsql.vim-2.1.0.tar.gz 2.1.0 2018-01-21 7.0 Lifepillar Update syntax coloring of data types. Updated for PostgreSQL 10.1.
pgsql.vim-2.0.0.tar.gz 2.0.0 2017-07-23 7.0 Lifepillar Syntax file is now generated automatically from a SQL script, so you won't miss a keyword! And you may rebuild it yourself against your PostgreSQL version! Several other small improvements, e.g., better support for psql commands.
pgsql.vim-1.1.1.tar.gz 1.1.1 2016-05-05 7.0 Lifepillar Highlight fixes.
pgsql.vim-1.1.0.tar.gz 1.1.0 2016-04-30 7.0 Lifepillar More keywords, a few bug fixes.
pgsql-v1.0.tar.gz 1.0 2016-03-29 7.4 Lifepillar Initial upload
ip used for rating:

If you have questions or remarks about this site, visit the vimonline development pages. Please use this site responsibly.
Questions about Vim should go to the maillist. Help Bram help Uganda.