Re: overwrite column data select - Postgres 9.2

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 9/20/2016 10:56 PM, Patrick B wrote:

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...

select 'test.UID@xxxxxxxxxxx' as email

-- 
john r pierce, recycling bits in santa cruz