Quick Links

overwrite column data select - Postgres 9.2

From:	Patrick B <patrickbakerbr(at)gmail(dot)com>
To:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	overwrite column data select - Postgres 9.2
Date:	2016-09-21 05:02:34
Message-ID:	CAJNY3iv7voOf-U1OyxEXTcR_YvgDbeWaN-UHu--98KWH7p7URw@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: overwrite column data select - Postgres 9.2 at 2016-09-21 05:26:27 from amul sul
Re: overwrite column data select - Postgres 9.2 at 2016-09-21 05:27:11 from John R Pierce
Re: overwrite column data select - Postgres 9.2 at 2016-09-21 18:50:06 from Steve Petrie, P.Eng.

Browse pgsql-general by date

	From	Date	Subject
Next Message	amul sul	2016-09-21 05:26:27	Re: overwrite column data select - Postgres 9.2
Previous Message	sangeetha	2016-09-20 12:18:43	PQexecFinish blocked forever in localhost also