From: | "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net> |
---|---|
To: | "'John Smith'" <jayzee(dot)smith(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: column insert/alter got me stumped! |
Date: | 2007-01-25 00:04:39 |
Message-ID: | 0ed401c74014$68cae740$6400a8c0@dualcore |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I think you want this:
update tablename set columname = 'value'
where column2 = 'value2';
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John Smith
Sent: Wednesday, January 24, 2007 5:59 PM
To: pgsql-general(at)postgresql(dot)org
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-01-25 00:30:05 | Re: [GENERAL] Autovacuum Improvements |
Previous Message | John Smith | 2007-01-24 23:58:30 | column insert/alter got me stumped! |