Dean Gibson (DB Administrator) wrote:
CREATE TABLE new_name AS SELECT DISTINCT * FROM old_name;
DROP TABLE old_name;
ALTER TABLE new_name RENAME TO old_name;
The problem with this technique is that it doesn't account for indexes,
foreign key references, and other dependencies.
Another ap
CREATE TABLE new_name AS SELECT DISTINCT * FROM old_name;
DROP TABLE old_name;
ALTER TABLE new_name RENAME TO old_name;
On 2005-11-04 17:15, Peter Atkins wrote:
All,
I have a duplicate row problem and to make matters worse some tables don't have a PK or any unique identifier.
Anyone have a
"Peter Atkins" <[EMAIL PROTECTED]> writes:
> I was hoping to have a system oid for each row but it looks like that's
> not the case. Anyone have any thoughts on how to remove dups?
ctid always works ...
regards, tom lane
---(end of broadcast)--
