Postgres - how do I return output to the terminal?

Question

I'm in the postgres terminal window and I've switched the output to a file using a command like

\o output.txt

but now I want to return the output to the terminal window, not the text file, without having to exit and log in again. How do I do that - I managed it once but can't now find it in the documentation ...

user330315 · Accepted Answer · 2013-09-20 14:53:18Z

4

From the manual:

\o [ {filename | |command} ]

    Saves future query results to the file filename or pipes future results 
    into a separate Unix shell to execute command. 
    If no arguments are specified, the query output will be reset to the 
    standard output.

(Emphasis mine)

answered Sep 20, 2013 at 14:53

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres - how do I return output to the terminal?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related