Postgres Pro
Downloads
Home   >   mailing lists

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

From John R Pierce
Subject Re: overwrite column data select - Postgres 9.2
Date
Msg-id 3a93b643-dd41-2a03-9373-ed9264021a47@hogranch.com
Whole thread Raw
In response to Re: overwrite column data select - Postgres 9.2  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: overwrite column data select - Postgres 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view
On 9/20/2016 10:56 PM, Patrick B wrote:
update table tablename set email = 'test.UID@example.com';     ?




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@example.com' as email


-- 
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: Rick Widmer
Date:
Subject: Re: overwrite column data select - Postgres 9.2
Next
From: Patrick B
Date:
Subject: Re: overwrite column data select - Postgres 9.2