Re: Killing output - Mailing list pgsql-novice

From Tom Lane
Subject Re: Killing output
Date
Msg-id 6130.977860443@sss.pgh.pa.us
Whole thread Raw
In response to Killing output  (Dave_Pfaltzgraff@patapsco.com)
List pgsql-novice
Dave_Pfaltzgraff@patapsco.com writes:
> If I'm in psql and do something stupid like:
> select * from table where date < '12/24/1000';
> where I meant to enter >, is there some way to kill the ouput so I
> don't have to > wait for all the output to complete before I can enter
> the correct command?

Recent versions of psql pipe the output through 'more' (or 'less', or
local equivalent) automatically.

If you are running a not-so-recent version, I believe that's still true,
but it may not be default behavior.  See psql docs concerning PAGER
environment variable.

Another possibility is that you have PAGER set to a value that prevents
this from happening (like "cat", say).

            regards, tom lane

pgsql-novice by date:

Previous
From: Dave_Pfaltzgraff@patapsco.com
Date:
Subject: Killing output
Next
From: "Robert B. Easter"
Date:
Subject: Re: Null and Not Null