Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group