sponsor Vim development Vim logo Vim Book Ad

pgsql : The best PostgreSQL plugin for Vim!

 script karma  Rating 1/3, Downloaded by 3070  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.
Vim at Github