dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlDump Class / IncludeBlob Property

In This Topic
IncludeBlob Property
In This Topic
Include large objects, associated with Oid filed values of dumped tables, in the dump.
Syntax
'Declaration
 
Public Property IncludeBlob As Boolean
 

Property Value

true, if large objects will be added to the database dump; otherwise, false. The default value is false.
Remarks

Only the large objects with oids (object identifier) from the dumped tables are dumped. That means that if a dumped table has an oid column and IncludeBlob=true, then all the oid values are verified for the existance of the corresponding large object, and these large objects are dumped. Don't forget that large objects oids should be stored in the oid type fields. Here is a simple DDL script that creates a table for storing oid references to the large objects.

 CREATE TABLE test.largeobj_table
(
  loid oid
)       

Setting this property to true may significant increase size of the dump and make difficult its representation because of great amount of binary data.

See Also