How do I change data type from text to bool?

From: "Donald Braman" <donald(dot)braman(at)yale(dot)edu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How do I change data type from text to bool?
Date: 2001-02-19 22:55:24
Message-ID: NEBBIEDPCOLBEHHPHCIMAEOBEBAA.donald.braman@yale.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Len Morgan 2001-02-20 00:03:37 Re: FW: Dbf to Pg converter
Previous Message Dan Lyke 2001-02-19 22:49:45 A How-To: PostgreSQL from Tcl via ODBC