I think you want this: update tablename set columname = 'value' where column2 = 'value2'; -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of John Smith Sent: Wednesday, January 24, 2007 5:59 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: [GENERAL] column insert/alter got me stumped! guys, just wanna change value of 1 existing column # insert into tablename (columnname) values ('value'); ...works # select columnname from tablename where columnname='value'; ...works # insert into tablename (columnname) values ('value') select columnname from tablename where columnname='value'; or # insert into tablename (columnname) values ('value') where columnname='value'; ...combinations don't work # alter table tablename alter column columnname set value='value'; ...doesn't work either embarrassingly simple? pgadmin III thinks so jzs http://www.postgresql.org/docs/8.1/static/sql-insert.html http://www.postgresql.org/docs/8.0/static/sql-altertable.html ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
