On Mon, Mar 10, 2008 at 10:50:26AM -0500, Kynn Jones wrote:
> Hi! When it comes to programming SQL, my newbie approach is to write my
> code in a file test.sql, which I test from within psql by using
>
> my_db=> \i /some/path/test.sql
>
> ...and (once I'm satisfied with the code) copy and paste it to a different
> file that has the SQL I've written so far for the project.
I'm not quite sure if this would help your use case, but a few editors
allow you to send blocks of text to other processes. For example, under
Emacs I can hit Ctrl+C twice and it will grab the current paragraph
and send it off to psql, showing the results in another window. Once
I'm happy with the statement I leave it and move on to the next job
(committing changes to some SCM when appropriate).
Sam