proposal - psql output file write mode

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: proposal - psql output file write mode
Date: 2020-03-28 05:30:06
Message-ID: CAFj8pRCish6bByKukG5tpuN4yc3+QM3xFBFJmX1i76ZYeEaEZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I am playing with pspg and inotify support. It is working pretty well and
now can be nice if forwarding to output file can be configured little bit
more. Now, only append mode is supported. But append mode doesn't work with
pspg pager. So I propose new pset option "file_output_mode" with two
possible values "append" (default, current behave) and "rewrite" (new mode).

Usage:

\pset file_ouput_mode rewrite

In this mode, the file is opened before printing and it is closed after
printing.

What do you think about this proposal?

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2020-03-28 06:21:33 Re: Berserk Autovacuum (let's save next Mandrill)
Previous Message Amit Kapila 2020-03-28 04:22:51 Re: error context for vacuum to include block number