Postgres Pro
Downloads
Home   >   mailing lists

Re: Modifying database schema without losing data - Mailing list pgsql-general

From Rich Shepard
Subject Re: Modifying database schema without losing data
Date
Msg-id alpine.LNX.2.20.2009281104090.31537@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Modifying database schema without losing data  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Modifying database schema without losing data
Next
From: Reid Thompson
Date:
Subject: Re: re PG 9.6x and found xmin from before relfrozenxid and removal of pg_internal.init file(s)