PgSqlDump and pg_largeobject
PgSqlDump and pg_largeobject
Hi Guys,
How can I dump the blob values stored in pg_largeobject sytem table using PgSqlDump Class? and restore the same.
Thanks,
OnisH
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.
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.
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.
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.
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?