Re: overwrite column data select - Postgres 9.2

2016-09-21 17:27 GMT+12:00 John R Pierce <pierce(at)hogranch(dot)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(dot)UID(at)example(dot)com
>
> How can I do that?
>
>
> update table tablename set email = 'test(dot)UID(at)example(dot)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)