Re: changing field length

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Gaetano Mendola <mendola(at)bigfoot(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: changing field length
Date: 2003-08-20 14:40:27
Message-ID: 3F43885B.5080802@virginia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

please ignore last message. I had my columns switched.
sorry about that!
Thanks for the quick response.
jodi

Bruno Wolff III wrote:

>On Wed, Aug 20, 2003 at 10:16:38 -0400,
> Jodi Kanter <jkanter(at)virginia(dot)edu> wrote:
>
>>how do I copy from one field to another?
>>
>
>update tablename set newcol = oldcol;
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Barnett-Cormack 2003-08-20 14:43:48 Re: Sobig.f in the list
Previous Message Jodi Kanter 2003-08-20 14:39:25 Re: changing field length