Re: Incorrect syntax when restoring a single table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Incorrect syntax when restoring a single table
Date: 2024-06-27 15:05:02
Message-ID: 1734113.1719500702@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ron Johnson <ronljohnsonjr(at)gmail(dot)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

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-06-27 15:23:10 Re: Incorrect syntax when restoring a single table
Previous Message Achilleas Mantzios - cloud 2024-06-27 15:01:22 Re: Incorrect syntax when restoring a single table