Re: delete column

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