Search Postgresql Archives

Re: overwrite column data select - Postgres 9.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2016-09-21 17:27 GMT+12:00 John R Pierce <pierce@xxxxxxxxxxxx>:
On 9/20/2016 10:02 PM, Patrick B wrote:
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?

update table tablename set email = 'test.UID@xxxxxxxxxxx';     ?




I can't overwrite the data into that column...

I was hopping that in a SELECT I could replace the data from the email column to something else...


maybe email = name_first + name_last? Is that possible?

I can't overwrite the data into that column... that has to be done by the select (if possible)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux