Re: 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: Re: proposal - psql output file write mode
Date: 2020-03-30 07:43:04
Message-ID: CAFj8pRA1n5=KixA_ofV0Pnemqtfhrq1RZ97eUh=1FW4jQRcEpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

so 28. 3. 2020 v 6:30 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
napsal:

> 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?
>

I tried to implement this feature and it doesn't look like good idea. There
is not trivial implementation, and looks so costs are higher than benefits.

Pavel

> Regards
>
> Pavel
>
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro Horiguchi 2020-03-30 07:53:10 Re: Race condition in SyncRepGetSyncStandbysPriority
Previous Message Michael Paquier 2020-03-30 07:43:00 Re: [HACKERS] WAL logging problem in 9.4.3?