"Tao Ma" <feng_eden@163.com> writes:
> Is it really important to show the
> 'bpchar' if there is no any explicit casting for the column default value.
Yeah. We cannot say "char" because per SQL spec, that means "char(1)",
but there mustn't be a restriction to a single character here.
regression=# select 'abc'::char;bpchar
--------a
(1 row)
regression=# select 'abc'::bpchar;bpchar
--------abc
(1 row)
regards, tom lane