I have a table which having an oid column. When I'm taking a backup of this table, it takes complete oids (complete blob / oids backup). But my table is having only 10 entries (which is approximately 30 entries in pg_largeobject table). I read the following link and added -o and -b in the backup parameter.
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 in my command? How I can take only the specific table backup with only those blobs that belong to it?
I read 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, there is no use / possibility to take selective table's backup with blob / oid ?