quickrun.vim for PostgreSQL(copied from http://potix2.blogspot.jp/2011/12/quickrunsqlmysql.html)

quickrun.vim

" PostgreSQL
let g:quickrun_config['sql'] = {
            \ 'command': 'psql',
            \ 'exec': ['%c %o < %s'],
            \ 'cmdopt': '%{MakepgsqlCommandOptions()}',
            \ }

let g:pgsql_config_host = ''
let g:pgsql_config_port = ''
let g:pgsql_config_user = ''
let g:pgsql_config_db = ''
function! MakepgsqlCommandOptions()
    if !exists("g:pgsql_config_host")
        let g:pgsql_config_host = input("host> ")
    endif
    if !exists("g:pgsql_config_port")
        let g:pgsql_config_port = input("port> ")
    endif
    if !exists("g:pgsql_config_user")
        let g:pgsql_config_user = input("user> ")
    endif
    if !exists("g:pgsql_config_db")
        let g:pgsql_config_db = input("database> ")
    endif

    let optlist = []
    if g:pgsql_config_user != ''
        call add(optlist, '-U ' . g:pgsql_config_user)
    endif
    if g:pgsql_config_host != ''
        call add(optlist, '-h ' . g:pgsql_config_host)
    endif
    if g:pgsql_config_port != ''
        call add(optlist, '-p ' . g:pgsql_config_port)
    endif
    if exists("g:pgsql_config_otheropts")
        call add(optlist, g:pgsql_config_otheropts)
    endif

    call add(optlist, g:pgsql_config_db)
    return join(optlist, ' ')
endfunction