Devart Forums

Hi Guys,

How can I dump the blob values stored in pg_largeobject sytem table using PgSqlDump Class? and restore the same.

Thanks,

OnisH

The PgSqlDump class includes the IncludeBlob property that allows to include field values of ByteA type into database dump. Have you tried using this property? Please describe the problem.

Hi,

Yes, I did tried after setting IncludeBlob to True but I am trying to dump the large objects which are stored in a system table named pg_largeobject.

Using IncludeBlob will dump only the data of type bytea? or will it also go to the system table "pg_largeobject" and dump the data from it?

I hope I was able to explain the scenario. Thanks.

PgSqlDump with enabled IncludeBlob works only with the data of type bytea. We will investigate the possibility of implementing the PgSqlDump support for PostgreSQL large objects. Currently, the PgSqlLargeObject class is available (it represents a PostgreSQL large object).

Hi,

Currently I am using PgSqlLargeObject class to save large objects to database, which works great by the way, but now I would also like to backup the same data, the large objects i.e.

It would be great if PgDump supports Large Object too, or please let me know if I can achieve this using some other way.

Thanks.

Hi Shalex,

Any inputs on my last reply?

Thanks.

We are investigating the possibility of implementing the PgSqlDump support for PostgreSQL large objects. Currently only manual retrieving and writing separate PostgreSQL large objects with PgSqlLargeObject is possible.

Understood, Thanks for your effort. I will be waiting for the update.

Regards.

Hi Guys,

Any update on this feature?

Thanks.

We are working on this feature. We plan to add this functionality in a month or so. I will post here when it is available.

Fantastic, I really appreciate. I had almost lost the hope. Thanks Guys.

We have implemented support for PgSqlLargeObject in PgSqlDump. I will post here when the corresponding build is available.

Fantastic, I really appreciate your support. Thanks a lot.

Hi Guys,

Any updates on this?

Support for PgSqlLargeObject in PgSqlDump is available in the 4.95.152 and 5.0.10 versions. Please refer to the updated documentation on this property. But we are still working on it. Please give us your feedback. What should be changed or improved from your point of view?