Postgres Pro
Downloads
Home   >   mailing lists

How do I change data type from text to bool? - Mailing list pgsql-general

From Donald Braman
Subject How do I change data type from text to bool?
Date
Msg-id NEBBIEDPCOLBEHHPHCIMAEOBEBAA.donald.braman@yale.edu
Whole thread Raw
Responses Re: How do I change data type from text to bool?
List pgsql-general
Tree view 
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 by date:

Previous
From: adb
Date:
Subject: max / min explain
Next
From: Dan Lyke
Date:
Subject: A How-To: PostgreSQL from Tcl via ODBC