Vim Tips Wiki

Quick and dirty Postgres query

1,612pages on
this wiki
Revision as of 09:53, October 7, 2013 by (Talk)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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" '

Around Wikia's network

Random Wiki