(Insert TipProposed template + minor manual clean) |
|||
| Line 3: | Line 3: | ||
|id=446 |
|id=446 |
||
|previous=445 |
|previous=445 |
||
| − | |next= |
+ | |next=449 |
|created=March 23, 2003 |
|created=March 23, 2003 |
||
|complexity=basic |
|complexity=basic |
||
| Line 12: | Line 12: | ||
|category2= |
|category2= |
||
}} |
}} |
||
| − | Here is a simple and |
+ | 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. |
| + | <pre> |
||
| − | |||
| − | + | map <F9> :!psql -d yourdb < % <BAR> less |
|
| + | </pre> |
||
==Comments== |
==Comments== |
||
| Line 21: | Line 22: | ||
---- |
---- |
||
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: |
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: |
||
| + | <pre> |
||
| − | |||
| − | + | export PSQL_EDITOR=vim |
|
| + | </pre> |
||
---- |
---- |
||
By default the buffer does not use the .sql extension. If you want syntax highlighting use: |
By default the buffer does not use the .sql extension. If you want syntax highlighting use: |
||
| + | <pre> |
||
| − | + | export PSQL_EDITOR='vim +"set syntax=sql" ' |
|
| + | </pre> |
||
Revision as of 03:49, 6 January 2010
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
Comments
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
By default the buffer does not use the .sql extension. If you want syntax highlighting use:
export PSQL_EDITOR='vim +"set syntax=sql" '