Re: [SQL] Replacing a table with constraints

2005-05-13 Thread Ragnar Hafstað
On Fri, 2005-05-13 at 14:38 -0400, Mark Fenbers wrote: > I have a table called Counties which partially contains a lot bad > data. By" bad data", I mean some records are missing; some exist and > shouldn't; and some records have fields with erroneous information. > However, the majority of the dat

Re: [SQL] Replacing a table with constraints

2005-05-13 Thread Scott Marlowe
Carrillo > > Ingeniero en ComputaciÃn > > Caracas - Venezuela > > > > > > > > - Original Message - > > From: Mark Fenbers > > To: pgsql-sql@postgresql.org > > Sent: Friday, May 13, 2005 2:38 PM > >

Re: [SQL] Replacing a table with constraints

2005-05-13 Thread Mark Fenbers
TABLE cascade   Jhon Carrillo Ingeniero en Computación Caracas - Venezuela     - Original Message - From: Mark Fenbers To: pgsql-sql@postgresql.org Sent: Friday, May 13, 2005 2:38 PM Subject: [SQL] Replacing a table with constraints I have a

Re: [SQL] Replacing a table with constraints

2005-05-13 Thread Ing. Jhon Carrillo
Use  Drop table YOUR_TABLE cascade   Jhon CarrilloIngeniero en ComputaciónCaracas - Venezuela     - Original Message - From: Mark Fenbers To: pgsql-sql@postgresql.org Sent: Friday, May 13, 2005 2:38 PM Subject: [SQL] Replacing a table with constraints I

[SQL] Replacing a table with constraints

2005-05-13 Thread Mark Fenbers
I have a table called Counties which partially contains a lot bad data.  By" bad data", I mean some records are missing; some exist and shouldn't; and some records have fields with erroneous information.  However, the majority of the data in the table is accurate.  I have built/loaded a new tab