dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlBlob Class / Length Property
Example

Length Property (PgSqlBlob)
Gets the size of the PgSqlBlob.
Syntax
'Declaration
 
Public Overrides ReadOnly Property Length As Long
 

Property Value

The size of the PgSqlBlob in bytes.
Remarks
The size of the PgSqlBlob is always returned in bytes for all data types.
Example
PgSqlDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
PgSqlBlob pictureBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture"));
if (pictureBlob.Length > 100)
  pictureBlob.SetLength(100);
Dim pictureReader As PgSqlDataReader = myCommand.ExecuteReader
pictureReader.Read()
Dim pictureBlob As PgSqlBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture"))
If (pictureBlob.Length > 100) Then
  pictureBlob.SetLength(CLng(100))
End If
See Also