On Wed, 26 Mar 2008 22:46:08 +0000,
Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:
[...]
> You could turn the problem around and make the bool columns into ints
> (which should be a simple search-and-replace, I hope) and then write
> something (again hopefully simple) to turn them all back into bools.
> I.e. lots of:
> ALTER TABLE my_table ALTER var_bool TYPE bool USING var_bool::bool;
Yes! Good idea, I think I can collect the names of the tables and
columns with boolean fields and then use that as you say. Thanks
everybody.
--
Seb