Thread: psql - use of deafult editor

Is there a way to temporarily turn of the use of a
default editor when using psql ?
I need to do this when I try to use psql from a
script/batch file. Whenever a query is executed psql
displays a result, displays it - I need to hit 'q' to
end the display and would like to avoid this
unnecessary (when running psql from a script) user
input.

Thanks,
Rini

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/

Rini Dutta writes:

> Is there a way to temporarily turn of the use of a
> default editor when using psql ?
> I need to do this when I try to use psql from a
> script/batch file. Whenever a query is executed psql
> displays a result, displays it - I need to hit 'q' to
> end the display and would like to avoid this
> unnecessary (when running psql from a script) user
> input.

That would be the pager, not the editor.  Use \pset pager.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/