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
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also