Re: Incorrect syntax when restoring a single table
| От | David G. Johnston |
|---|---|
| Тема | Re: Incorrect syntax when restoring a single table |
| Дата | |
| Msg-id | CAKFQuwa3R-rX-c8O+GsG-xT5_TaDT1cy_m0X-Z0Gkz1AWV1Y3g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Incorrect syntax when restoring a single table (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Список | pgsql-admin |
On Thursday, June 27, 2024, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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_y2022m08That 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.
I suppose writing the extra matching logic for in-file matching was more difficult than doing the same when the data sits in catalogs and you have a regexp operator. Less a bug and more a decision of convenience I suppose. No pressure from me to change it.
On a related note, the third tip refers to an out-of-support version. Shouldn’t we do away with it?
David J.
В списке pgsql-admin по дате отправления: