Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> Oops my mistake! I actually didn't use select into to create the table,
>> because I didn't want the columns exactly the same as before - was
>> switching from varchar to text.
> Oh, yes, that makes sense for your case. You can't control the data
> types with SELECT INTO.
You could with an explicit cast:
SELECT varcharcol::text INTO newtable FROM ...
regards, tom lane