Hi all,
I am new to Postgres and now I am doing some programming in pl/pgsql. At
this moment I am wirting procedures with a text editor and pasting them
on psql commandline via putty (with the annoyance that you cannot paste
more than a certain amount of text, so I have to slice them).
Since I use and enjoy Vim directly from the server vis ssh, I wish to
know if there is a way to create/edit pl/pgsql procedures directly from
Vim. Dou you have a tip?

Thanks,

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> wrote:
You can use vim and store your function into a regular file. After that,
within psql, you can read that file with \i <your_file>.

Other way, within psql, you can use \e to edit the current query buffer
with your $EDITOR.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> wrote:
You can use vim and store your function into a regular file. After that,
within psql, you can read that file with \i <your_file>.

Other way, within psql, you can use \e to edit the current query buffer
with your $EDITOR.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> wrote:
You can use vim and store your function into a regular file. After that,
within psql, you can read that file with \i <your_file>.

Other way, within psql, you can use \e to edit the current query buffer
with your $EDITOR.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> wrote:
You can use vim and store your function into a regular file. After that,
within psql, you can read that file with \i <your_file>.

Other way, within psql, you can use \e to edit the current query buffer
with your $EDITOR.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> wrote:
You can use vim and store your function into a regular file. After that,
within psql, you can read that file with \i <your_file>.

Other way, within psql, you can use \e to edit the current query buffer
with your $EDITOR.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> wrote:
You can use vim and store your function into a regular file. After that,
within psql, you can read that file with \i <your_file>.

Other way, within psql, you can use \e to edit the current query buffer
with your $EDITOR.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> wrote:
You can use vim and store your function into a regular file. After that,
within psql, you can read that file with \i <your_file>.

Other way, within psql, you can use \e to edit the current query buffer
with your $EDITOR.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> wrote:
You can use vim and store your function into a regular file. After that,
within psql, you can read that file with \i <your_file>.

Other way, within psql, you can use \e to edit the current query buffer
with your $EDITOR.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

Andreas Kretschmer ha scritto:
Simply great, thanks!