Re: overwrite column data select - Postgres 9.2

​First try to get backup using pg_dump & replace all data in email column.

Restore table backup once you done with your testing.

Regards,
Amul.

On Wed, Sep 21, 2016 at 10:32 AM, Patrick B <patrickbakerbr(at)gmail(dot)com>
wrote:

> Hi guys,
>
> 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?
> Thanks!
> Patrick
>