Re: alter column type from boolean to char with default

"Andrew Hammond" <andrew.george.hammond@gmail.com> writes:
> Alternatively, you already have the USING clause to tell you how to
> alter the data. How about using it to alter the default as well?

The reasons not to do that are already set forth in the ALTER TABLE
man page.
        regards, tom lane