Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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