Re: overwrite column data select - Postgres 9.2

> 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

In my mind, that's not a DB issue but an application issue since Pg doesn't send email (or I haven't seen that ability in it). So change the application that does the sending and comment out the "send" call. If you don't have the source for the app and can't do that, then disable the sending part at the OS level; a good sys-admin should have no trouble with that (turning off sendmail or whatever).

HTH,
Kevin