Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 578889FC049 for ; Thu, 18 Oct 2007 11:13:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 99005-01 for ; Thu, 18 Oct 2007 11:13:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.229]) by postgresql.org (Postfix) with ESMTP id 1806F9FC065 for ; Thu, 18 Oct 2007 11:13:13 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id r21so151624wxc for ; Thu, 18 Oct 2007 07:13:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=0vFpi/W/8Bf3XzaAk9LiBcrqRkZPDC68gSNltY83nQY=; b=FwmScrLFUejBFoj3FSvidCBE+P0oh5dizQ3yZfbLQWaKAWjw0ujfboH6AMaV3BVqmN5rwMP1AamBsrd4IgHgTZb0mDMe1e9nDw/yrANX5243yumOHbtFc/KYPKhr/LqZmXOlNWOo2yzSYpVhgkPgFAgtpgOFDNqC/qRtSg0s9es= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=j1tkmc9fGTuMG5BLwAEXMqKzKL8htRy1bv4XnUdfsTYmBWyKS7EovrQJgb9IlHeE8itTFQJC3SnTlir7eExwFLPF97OCsIhiTa4xnHEHjhcTDM6SR6iInw2LdQYgZDB676dxm6j+JJaSPBVszhSUr8vfWytqRjaFYxb0zhj8O1c= Received: by 10.90.88.13 with SMTP id l13mr1031001agb.1192716386954; Thu, 18 Oct 2007 07:06:26 -0700 (PDT) Received: by 10.90.117.8 with HTTP; Thu, 18 Oct 2007 07:06:26 -0700 (PDT) Message-ID: Date: Thu, 18 Oct 2007 09:06:26 -0500 From: "=?UTF-8?Q?Rodrigo_De_Le=C3=B3n?=" To: "Kostis Mentzelos" Subject: Re: convert char to varchar Cc: pgsql-admin@postgresql.org In-Reply-To: <4716EDD7.7010104@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4716EDD7.7010104@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/168 X-Sequence-Number: 27082 On 10/18/07, Kostis Mentzelos 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);