On Thu, Jun 27, 2024 at 11:05 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>
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.