Re: Removing duplicate rows in table
Rich Shepard <rshepard@appl-ecosys.com>
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Date: 2024-09-10T15:29:44Z
Lists: pgsql-general
On Tue, 10 Sep 2024, Adrian Klaver wrote: > Is there a Primary Key or Unique index on this table? Adrian, No. It didn't occur to me to make the project number a PK as this table is not related to others in the database. But, yesterday it occurred to me to make the proj_nbr a PK to eliminate future issues. Thanks, Rich