Vim Tips Wiki

Quick and dirty Postgres query

Redirected from VimTip446

1,623pages on
this wiki
Add New Page
Add New Page Talk0
Tip 446 Printable Monobook Previous Next

created March 23, 2003 · complexity basic · author Shawn Deleurme · version 5.7

Here is a simple and useful mapping for anyone who can't stand developing queries on the psql prompt or messing around with the single \e psql edit buffer.

map <F9> :!psql -d yourdb < % <BAR> less


You could also consider use the database extension plugin for Vim, which provides a lot of features for Postgress. script#356 db_ext.vim

One other way of using vim with the \e command in psql is to set the PSQL_EDITOR environment variable. On a redhat system you'd do the following:

export PSQL_EDITOR=vim

When using old versions of psql the buffer does not have the .sql extension. If you want syntax highlighting use:

export PSQL_EDITOR='vim +"set syntax=sql" '

Also on Fandom

Random Wiki