Search Postgresql Archives

Re: pg_dump parameter

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


2022. 01. 06. 15:37 keltezéssel, David G. Johnston írta:
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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux