Postgres Pro
Downloads
Home   >   mailing lists

Re: Incorrect syntax when restoring a single table - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Incorrect syntax when restoring a single table
Date
Msg-id CANzqJaCkMYpSQUpcfUi7KnrH_+C7v-z0SUEoSR=y3OVmyqmOOg@mail.gmail.com
Whole thread Raw
In response to Re: Incorrect syntax when restoring a single table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Incorrect syntax when restoring a single table
List pgsql-admin
Tree view
On Thu, Jun 27, 2024 at 11:05 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ron Johnson <ronljohnsonjr@gmail.com> writes:
> $ pg_restore -v -a -t tapschema.batch_rp4_y2022m08 -Fd --dbname=tap tap

I think what you have to do is write -n tapschema -t batch_rp4_y2022m08
 
That indeed is the solution.  Should have seen it in the docs.

pg_restore's use of "-t" is inconsistent with other utilities (pg_dump, vacuumdb, reindexdb, clusterdb).  That seems to be a design bug.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Incorrect syntax when restoring a single table
Next
From: "David G. Johnston"
Date:
Subject: Re: Incorrect syntax when restoring a single table