Re: Large Objects

> a) What is the distinction between our data type TEXT and the SQL:2011 data type CLOB which we do not support
(T041)?

I'd say there is no difference. 
> b) Is there a distinction between the two Postgres data types TEXT and "CHARACTER VARYING without specifying a
length"
 
> or are they only synonym terms without different functionalities and capabilities?

No there is no difference.

Quote from the manual [1]

> Tip: There is no performance difference among these three types, 
> apart from increased storage space when using the blank-padded type

Thomas


[1] https://www.postgresql.org/docs/current/static/datatype-character.html