How do I change data type from text to bool?

Поиск
Список
Период
Сортировка
От Donald Braman
Тема How do I change data type from text to bool?
Дата
Msg-id NEBBIEDPCOLBEHHPHCIMAEOBEBAA.donald.braman@yale.edu
обсуждение исходный текст
Ответы Re: How do I change data type from text to bool?  ("Brent R. Matzelle" <bmatzelle@yahoo.com>)
Список pgsql-general
I have a table/class filled with records/instances in which I accidentally
set the fields/attributes data type to text rather than boolean. I now have
75,000 records with 't' and 'f' So now I want to change the attributes to
bool? I can't find anything on changing data types in the integrated docs (I
searched them, didn't read all of them). Did I miss it? Is there an easy way
to do this? -Don


В списке pgsql-general по дате отправления:

Предыдущее
От: adb
Дата:
Сообщение: max / min explain
Следующее
От: Dan Lyke
Дата:
Сообщение: A How-To: PostgreSQL from Tcl via ODBC