"Tao Ma" <feng_eden(at)163(dot)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