For vim users, there is an awesome plugin to talk to postgres and a ton of other databases called dbext.vim https://github.com/vim-scripts/dbext.vim Setting it up takes a little effort though.