RE: [GENERAL] Modify Column

2000-12-01 Thread Tamsin
ginal Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > [EMAIL PROTECTED] > Sent: 01 December 2000 16:32 > To: [EMAIL PROTECTED] > Subject: Re: [GENERAL] Modify Column > > > > > I don't know if you can use ALTER TABLE to do t

Re: [GENERAL] Modify Column

2000-12-01 Thread joe
Thanks - It's a fairly small table so I decided to create a new field and update the table. My syntax was UPDATE tablename SET new_column = old_column WHERE uid = uid; However it says: Relation 'tablename' does not have attribute 'new_column' If i do \d tablename, it shows the new column. Did I m

Re: [GENERAL] Modify Column

2000-12-01 Thread martin . chantler
] on 01/12/2000 15:23:03 Please respond to [EMAIL PROTECTED] To: PostgreSQL General <[EMAIL PROTECTED]> cc:(bcc: Martin Chantler/CIMG/CVG) Subject: [GENERAL] Modify Column This seems like a simple enough thing, and I'm sure it's been answered, but I couldn't f

Re: [GENERAL] Modify Column

2000-12-01 Thread Robert B. Easter
On Friday 01 December 2000 10:23, [EMAIL PROTECTED] wrote: > This seems like a simple enough thing, and I'm sure it's been answered, > but I couldn't find anything that helped in the archives. Basically, I > have a column in my table that was, once upon a time, large enough, but > now, I need to i

[GENERAL] Modify Column

2000-12-01 Thread joe
This seems like a simple enough thing, and I'm sure it's been answered, but I couldn't find anything that helped in the archives. Basically, I have a column in my table that was, once upon a time, large enough, but now, I need to increase the site of the column. How can I do that? Thanks, Joe