What is the difference between character varying and text?

Question

PostgreSQL

The documentation says that both types can store strings of arbitrary length, except that character varying can limit this arbitrariness.

Answer 1

you can store strings of arbitrary length, except that in character varying you can limit this arbitrariness

And there is. No more difference