Re: ISO something like "#if 0 ... #endif" for SQL code - Mailing list pgsql-general

From Kynn Jones
Subject Re: ISO something like "#if 0 ... #endif" for SQL code
Date
Msg-id c2350ba40803111018m12675a0cy2beb51c0d13a633c@mail.gmail.com
Whole thread Raw
In response to Re: ISO something like "#if 0 ... #endif" for SQL code  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
On Tue, Mar 11, 2008 at 7:17 AM, Sam Mason <sam@samason.me.uk> wrote:

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.

That's a neat trick.  The display in the interactive *SQL* (for me anyway) is a bit buggy (some newlines are not being inserted where I would expect them), but this is only a minor annoyance.  Being able to execute a chunk of buffer on the spot like that is just awesome.  (I like Ctrl-C Ctrl-C OK, but I like Ctrl-C Ctrl-R even more.)

Thanks!

Kynn

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: Database OID xxxxx now seems to belong to "foo"
Next
From: "Robert James"
Date:
Subject: Normalizing denormalization with materialized views