Re: proposal: pg_restore --convert-to-text - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: proposal: pg_restore --convert-to-text
Date
Msg-id df8b99c3-2820-96cb-6669-4ee141ff81e4@proxel.se
Whole thread Raw
In response to Re: proposal: pg_restore --convert-to-text  (Euler Taveira <euler@timbira.com.br>)
Responses Re: proposal: pg_restore --convert-to-text  (Euler Taveira <euler@timbira.com.br>)
List pgsql-hackers
On 14/02/2019 01.31, Euler Taveira wrote:
> Em qua, 13 de fev de 2019 às 19:56, Andrew Gierth
> <andrew@tao11.riddles.org.uk> escreveu:
>> I propose we add a new option: --convert-to-text or some such name, and
>> then make pg_restore throw a usage error if neither -d nor the new
>> option is given.
>>
> However, I agree that pg_restore to stdout if -d wasn't specified is
> not a good default. The current behavior is the same as "-f -"
> (however, pg_restore doesn't allow - meaning stdout). Isn't it the
> case to error out if -d or -f wasn't specified? If we go to this road,
> -f option should allow - (stdout) as parameter.

Agreed, "-f -" would be acceptable. I use pg_restore to stdout a lot, 
but almost always manually and would have to have to remember and type 
"--convert-to-text".

Andreas


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Early WIP/PoC for inlining CTEs
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Using POPCNT and other advanced bit manipulation instructions