Postgres Pro
Downloads
Home   >   mailing lists

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

FromRodrigo De León
SubjectRe: convert char to varchar
Date
Msg-id[email protected]
Whole thread Raw
In response toconvert char to varchar  (Kostis Mentzelos <[email protected]>)
Listpgsql-admin
Tree view
On 10/18/07, Kostis Mentzelos <[email protected]> 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);

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Drop Not Null
Next
From: "Scott Marlowe"
Date:
Subject: Re: Is my database now too big?