Postgres Pro
Downloads
Home   >   mailing lists

Re: overwrite column data select - Postgres 9.2 - Mailing list pgsql-general

From amul sul
Subject Re: overwrite column data select - Postgres 9.2
Date
Msg-id CAAJ_b97WgRN17DTnBajXSmn+GcJQcUPTJEppdEnYBOJYR2yJEA@mail.gmail.com
Whole thread Raw
In response to overwrite column data select - Postgres 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view
​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@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.UID@example.com

How can I do that?
Thanks!
Patrick

pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: overwrite column data select - Postgres 9.2
Next
From: John R Pierce
Date:
Subject: Re: overwrite column data select - Postgres 9.2