Re: overwrite column data select - Postgres 9.2

[amul sul <sulamul@xxxxxxxxx>]

​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@xxxxxxxxx> 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.UID@xxxxxxxxxxx

How can I do that?

Thanks!

Patrick