2016-09-21 17:27 GMT+12:00 John R Pierce <pierce@xxxxxxxxxxxx>:
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.UID@xxxxxxxxxxx
How can I do that?
update table tablename set email = 'test.UID@xxxxxxxxxxx'; ?
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)