Re: Lookup tables

Rich Shepard <rshepard@xxxxxxxxxxxxxxx> · Tue, 4 Feb 2025 11:08:42 -0800 (PST)

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