Re: How to find not unique rows in a table? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: How to find not unique rows in a table?
Date
Msg-id D960CB61B694CF459DCFB4B0128514C20296662E@exadv11.host.magwien.gv.at
Whole thread Raw
In response to How to find not unique rows in a table?  ("A B" <gentosaker@gmail.com>)
List pgsql-general
A B wrote:
> Assuming you have a table where some rows have the same values in all
> columnes, how do you find these rows?

There is no reliable, time-independent way.
That's one reason why you have primary keys on tables.

There is the system column "ctid", but that may change any second.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: 8.4 RPMs
Next
From: Oliver Kohll
Date:
Subject: Re: Stats collector eats my CPU