How did you dump only one table, the pg_restore
would only have an object to restore. Anyway there is the parameter -t
to define the tables that will be restored.
pg_restore -t public.lotesretornosuprimento -d BancoDados C:\Backup\Backup_table.backup
If you want to restore only the data, without sending the commands to create the schema, use the parameter -a
.
If it is necessary to recreate objects before restoring use the parameter -c
.
More details about the pg_restore
can be found in the postgres documentation: https://www.postgresql.org/docs/current/static/app-pgrestore.html
https://makandracards.com/zeroglosa/27675-gerar-e-restaurar-backup-de-apenas-uma-tabela-postgres see if this helps you.
– Doan Casotti