On 10/18/07, Peter Koczan <pjkoczan(at)gmail(dot)com> wrote:
> > Is there any other way to clear trailing spaces when I restore the table?
> If you're running 8.x, you can do this in place:
> ALTER TABLE c1 ALTER COLUMN name varchar(20) USING rtrim(name), ALTER
> COLUMN date varchar(20) USING rtrim(date);
> This could take a long time if the table is large or has a lot of indexes on it.
Oops. The command should be:
ALTER TABLE c1 ALTER COLUMN name TYPE varchar(20) USING rtrim(name),
ALTER COLUMN date TYPE varchar(20) USING rtrim(date);
I forgot the TYPE keyword...it's important.
In response to
pgsql-admin by date
|Next:||From: Alvaro Herrera||Date: 2007-10-18 16:25:37|
|Subject: Re: could not open file "global/pg_database"|
|Previous:||From: Peter Koczan||Date: 2007-10-18 15:35:40|
|Subject: Re: convert char to varchar|