Date: Tue, 4 Feb 2025 11:08:42 -0800 (PST)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Subject: Re: Lookup tables
In-Reply-To: <0def87f9-6fa6-49a7-b0bc-f313c066d387@gmail.com>
Message-ID: <4c55f93-bff-a452-69da-6db5a5a33b33@appl-ecosys.com>
References: <4e7a338-c7d3-e944-20bd-a6e346e175c7@appl-ecosys.com>
 <0def87f9-6fa6-49a7-b0bc-f313c066d387@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=US-ASCII
Archived-At: 
 <https://www.postgresql.org/message-id/4c55f93-bff-a452-69da-6db5a5a33b33%40appl-ecosys.com>
Precedence: bulk

On Tue, 4 Feb 2025, Rob Sargent wrote:

> Unless your lookup tables are huge I would create a new table matching
> your current table but with an identity column and load from you original
> table.

I created a new table:

create table ind_types_lu (
   ind_nbr serial primary key,
   ind_name varchar(32) not null
);

Now the database has the new table and a new sequence:

  public | ind_types_lu             | table    | rshepard
  public | ind_types_lu_ind_nbr_seq | sequence | rshepard

I want to replace the old lookup table (with no FK) with this one. Can I
use:

alter table rename ind_types_lu to industrytypes;

and have the sequence name changed, too?

TIA,

Rich