pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: pgsql-hackers@postgresql.org
Subject: proposal: pg_restore --convert-to-text
Date: Wed, 13 Feb 2019 22:56:04 +0000
Message-ID: <87sgwrmhdv.fsf@news-spur.riddles.org.uk> (raw)

One of the remarkably common user errors with pg_restore is users
leaving off the -d option. (We get cases of it regularly on the IRC
channel, including one just now which prompted me to finally propose
this)

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.

Opinions?

(Yes, it will break the scripts of anyone who is currently scripting
pg_restore to output SQL text. How many people do that?)

-- 
Andrew (irc:RhodiumToad)




view thread (19+ messages)  latest in thread

Message-ID: <87sgwrmhdv.fsf@news-spur.riddles.org.uk>
Permalink:  ../87sgwrmhdv.fsf@news-spur.riddles.org.uk/
Also on:    postgresql.org/message-id/87sgwrmhdv.fsf@news-spur.riddles.org.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: andrew@tao11.riddles.org.uk
  Subject: Re: proposal: pg_restore --convert-to-text
  In-Reply-To: <87sgwrmhdv.fsf@news-spur.riddles.org.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox