Hi Augusto,
if you used lo (large object) instead of bytea, you could exclude those large objects from the dump with the --no-blobs option of pg_dump.
Note that lo and bytea solve similar problems, but in markedly different ways. For example, large objects are managed by functions, they are stored outside of the table etc.
If you are using bytea, you might work around the issue in some
ways.
For example, you may do a CREATE TEMPORARY TABLE ... AS SELECT
..., omit bytea columns in the select list, and dump the temporary
table instead.
If you are dumping into plain-text file format with pg_dump, you
may use COPY (or \copy) instead, and only unload selected columns.
None of the above, however, is exactly what you want I am afraid.
Regards,
tamas
On Thursday, January 6, 2022, Augusto Mossambani <augusto@xxxxxxxxxxxxx> wrote:
Hi.Is there a way when using pg_dump, inform a parameter to "clean" a certain column (ByteA) of a table, similar to oracle(Blob)? Oracle Example: Remap_data=TABLE.COLUMN_NAME:clear_blob_pack.clear_blob
Not that I’m aware of.
David J.
