BLOB vs BYTEA

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
tabsautobiz
Posts: 5
Joined: Wed 08 Jun 2011 18:33

BLOB vs BYTEA

Post by tabsautobiz » Wed 08 Jun 2011 18:39

I see in the documentation that you support accessing data from BYTEA PosgreSQL types, but haven't seen anything about BLOBs. Do you currently support pg BLOBs?

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 10 Jun 2011 09:55

PostgreSQL has two forms of storing 'large objects':
1) bytea data type that contains a variable-length stream of binary data. It is supported via the PgSqlBlob class.
2) a 'Large Object' interface - refer to the PgSqlLargeObject class.

Post Reply