pg_restore should accept multiple -t switches?

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_restore should accept multiple -t switches?
Date: 2010-08-10 08:13:22
Message-ID: AANLkTikoJ1qZfyxHVh4xUEp0G92kCfXrevR3+ybtPseX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

pg_dump allows us to select multiple target tables by using
multiple -t switches, but pg_restore does not. So, when
restoring multiple tables, we have to run pg_restore more
than once as follows. This is a pain to me.

$ pg_restore -t tbl1 db.dump
$ pg_restore -t tbl2 db.dump

Is it worth allowing pg_restore to accept multiple -t
switches as well as pg_dump?

$ pg_restore -t tbl1 -t tbl2 db.dump

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Boxuan Zhai 2010-08-10 09:08:08 Re: MERGE Specification
Previous Message Joseph Adams 2010-08-10 08:03:43 Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)