How do I change data type from text to bool?

From: "Donald Braman" <donald(dot)braman(at)yale(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: How do I change data type from text to bool?
Date: 2001-02-19 23:39:08
Message-ID: NEBBIEDPCOLBEHHPHCIMEEOEEBAA.donald.braman@yale.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Donald Braman
donald(dot)braman(at)yale(dot)edu

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stefan Waidele jun. 2001-02-20 09:03:18 Re: ODBC linked table in access on second pc
Previous Message Dan Hoover 2001-02-19 21:45:48 Win32 Client Tools