​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 <patrickbake...@gmail.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....@example.com > > How can I do that? > Thanks! > Patrick >
