2016-09-21 17:27 GMT+12:00 John R Pierce <pie...@hogranch.com>: > On 9/20/2016 10:02 PM, Patrick B wrote: > > I've got a table with email column: > >> email CHARACTER VARYING(50) DEFAULT ''::CHARACTER VARYING NOT NULL, > > > There are 30k rows and the email column is not null... there is data in > there. > But for testing purpose I need to overwrite the email. So the customer > won't get an email from me while testing code. > > The email could be replaced by: test....@example.com > > How can I do that? > > > update table tablename set email = 'test....@example.com'; ? > > >
I can't overwrite the data into that column... I was hopping that in a SELECT I could replace the data from the email column to something else... maybe email = name_first + name_last? Is that possible? I can't overwrite the data into that column... that has to be done by the select (if possible)
