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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
