Received: from pop2-rme.xtra.co.nz (pop2-rme.xtra.co.nz [203.96.92.7]) by hub.org (8.10.1/8.10.1) with ESMTP id e5N5A7197314 for ; Fri, 23 Jun 2000 01:10:07 -0400 (EDT) Received: from berty ([210.55.121.67]) by pop2-rme.xtra.co.nz (InterMail vM.4.01.02.17 201-229-119) with SMTP id <20000623050958.JSEA810.pop2-rme.xtra.co.nz@berty>; Fri, 23 Jun 2000 17:09:58 +1200 From: Christopher Sawtell Organization: iOpen Technologies Ldt To: "Gary MacMinn" , pgsql-sql@postgresql.org Subject: Re: Merging two columns into one Date: Fri, 23 Jun 2000 17:10:38 +1200 X-Mailer: KMail [version 1.0.29.1] Content-Type: text/plain References: In-Reply-To: MIME-Version: 1.0 Message-Id: <00062317123201.15938@berty> Content-Transfer-Encoding: 8bit X-Archive-Number: 200006/200 On Fri, 23 Jun 2000, Gary MacMinn wrote: > Hi All, > > I have two columns in a table (areacode and phone number) that I'd like to merge into one (phone number) containing both sets of info. Could anyone suggest a simple way of achieving this? export the data to a file using the copy command, remove the delimiter with the unix command 'tr -d' import the file, now minus the delimeter using the copy command. -- Sincerely etc., NAME Christopher Sawtell - iOpen Technologies Ltd. CELL PHONE 021 257 4451 ICQ UIN 45863470 EMAIL chris @ iopen . co . nz, csawtell @ xtra . co . nz WWW http://www.iopen.co.nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--