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
In response to
pgsql-general by date
|Next:||From: Jochem van Dieten||Date: 2002-04-27 15:11:20|
|Subject: Re: delete column|
|Previous:||From: Thomas Lockhart||Date: 2002-04-27 14:56:53|
|Subject: Mandrake 8.1 RPMs posted|