Re: Modifying database schema without losing data

Поиск
Список
Период
Сортировка
Искать
От
Rich Shepard
Тема
Re: Modifying database schema without losing data
Дата
Msg-id
alpine.LNX.2.20.2009281104090.31537@salmo.appl-ecosys.com
Ответ на
Re: Modifying database schema without losing data (Adrian Klaver)
Список
Дерево обсуждения
Modifying database schema without losing data Rich Shepard <rshepard@appl-ecosys.com>
Re: Modifying database schema without losing data Adrian Klaver <adrian.klaver@aklaver.com>
Re: Modifying database schema without losing data Rich Shepard <rshepard@appl-ecosys.com>
Re: Modifying database schema without losing data Adam Scott <adam.c.scott@gmail.com>
Re: Modifying database schema without losing data Rich Shepard <rshepard@appl-ecosys.com>
Re: Modifying database schema without losing data Tom Lane <tgl@sss.pgh.pa.us>
Re: Modifying database schema without losing data Rich Shepard <rshepard@appl-ecosys.com> 
On Mon, 28 Sep 2020, Adrian Klaver wrote:

> You could use INSERT INTO location(new_fields,) SELECT the_fields FROM
> the_table(s).

Well, duh! I could have thought of that. That's exactly what I'll do:

Create the new table, move data from the old table into it, then drop
columns in the old table ... after checking all data's there.

Thanks, Adrian.

Stay well,

Rich
В списке pgsql-general по дате отправления
Предыдущее
От: Adrian Klaver
Дата:
Следующее
От: Reid Thompson
Дата:
FAQ