I have a table which has an oid column. When I'm taking a backup of this table, it takes complete oids (complete blob / oids backup). But my table only has 10 entries (which is approximately 30 entries in pg_largeobject table). I read the following link and added -o and -b to the backup parameters.
I am using below command to take backup.
pg_dump -i -h myhost -p 5432 -U myuser -F c -v -t schema.my_table -o -b -f mytablebkp.backup "mydb"
Is anything wrong with that command? How can I take a backup of only the specific table with only those blobs that belong to it?
I read the following from documentation (https://www.postgresql.org/docs/9.5/static/app-pgrestore.html),
pg_restore cannot restore large objects selectively; for instance, only those for a specific table. If an archive contains large objects, then all large objects will be restored, or none of them if they are excluded via -L, -t, or other options
Since pg_restore can not do selective restore, is there no way / possibility to take selective table backups with blob / oid ?