Re: Large Objects

Jürgen Purtz schrieb am 07.10.2016 um 21:31:
> - Types a) and b) are named identical in the standard and in Postgres
> (CHAR/VARCHAR). Data type c) is named CLOB in the standard and TEXT
> in Postgres.

>Why this different wording, if there is no real
> difference between the terms?

I guess because of historical reasons.

But if you need CLOB, then just define it:
  create domain clob as text;  create table foo (id integer, c1 clob);

Although I do agree that it would make sense to create CLOB as an alias for text and BLOB an alias for bytea.