--On samedi 27 avril 2002 11:08 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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 ...
I really think that :
CREATE new (all without the one(s) we don't want and their defaults)
INSERT INTO new select ... from old;
ALTER TABLE new RENAME TO old;
is the better.
In response to
pgsql-general by date
|Next:||From: Jeff Davis||Date: 2002-04-27 18:42:04|
|Subject: Re: requesting features in PostgreSQL|
|Previous:||From: Tom Lane||Date: 2002-04-27 15:39:17|
|Subject: Re: requesting features in PostgreSQL |