Re: overwrite column data select - Postgres 9.2
| От | Patrick B |
|---|---|
| Тема | Re: overwrite column data select - Postgres 9.2 |
| Дата | |
| Msg-id | CAJNY3itumpByur8a9Pw51gdWxPG7Cwuh1VDWXL9NvbkpG_rUWA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: overwrite column data select - Postgres 9.2 (John R Pierce <pierce@hogranch.com>) |
| Ответы |
Re: overwrite column data select - Postgres 9.2
Re: overwrite column data select - Postgres 9.2 |
| Список | pgsql-general |
2016-09-21 17:27 GMT+12:00 John R Pierce <pierce@hogranch.com>:
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@example.comHow can I do that?
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...
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)
В списке pgsql-general по дате отправления: