Re: ISO something like "#if 0 ... #endif" for SQL code

From: "Kynn Jones" <kynnjo(at)gmail(dot)com>
To: "Sam Mason" <sam(at)samason(dot)me(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ISO something like "#if 0 ... #endif" for SQL code
Date: 2008-03-11 17:18:25
Message-ID: c2350ba40803111018m12675a0cy2beb51c0d13a633c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 11, 2008 at 7:17 AM, Sam Mason <sam(at)samason(dot)me(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert James 2008-03-11 17:19:01 Normalizing denormalization with materialized views
Previous Message Gauthier, Dave 2008-03-11 17:06:50 Re: Database OID xxxxx now seems to belong to "foo"