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

From: Rick <ellis(at)spinics(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ISO something like "#if 0 ... #endif" for SQL code
Date: 2008-03-18 18:41:57
Message-ID: 1205865717.355534@no.spam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <20080311111755(dot)GR1653(at)frubble(dot)xen(dot)chris-lamb(dot)co(dot)uk>,
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. Once
>I'm happy with the statement I leave it and move on to the next job
>(committing changes to some SCM when appropriate).

You can do that with vi (or vim) as well. Sending a paragraph would
be !}psql

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2008-03-18 18:50:49 Re: Get index information from information_schema?
Previous Message Dawid Kuroczko 2008-03-18 18:39:41 Re: Feature request/suggestion - CREATE SCHEMA LIKE