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  (Rick Widmer <pgsql@rickwidmer.com>)
Re: overwrite column data select - Postgres 9.2  (John R Pierce <pierce@hogranch.com>)
Список 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.com

How 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: overwrite column data select - Postgres 9.2
Следующее
От: Rick Widmer
Дата:
Сообщение: Re: overwrite column data select - Postgres 9.2