Re: convert char to varchar - Mailing list pgsql-admin

On 10/18/07, Kostis Mentzelos <mentzelos@gmx.net> wrote:
> Is there any other way to clear trailing spaces when I restore the table?

After you restore, you can do:

UPDATE V1
SET
  NAME = TRIM(TRAILING ' ' FROM NAME)
, DATE = TRIM(TRAILING ' ' FROM DATE);