Re: Replacing a table with constraints - Mailing list pgsql-sql

True, but Counties has about 8 or 9 rules, view, or pk constraints attached to it.  I don't want to break all these
unlessI knew of a way to save off the SQL for them beforehand so I can easily rebuild them...<br /> Mark<br /><br />
Ing.Jhon Carrillo wrote: <blockquote cite="mid01c301c557ec$9983b090$1400a8c0@tgusta2"
type="cite"><style></style><div><fontcolor="#000000" face="Arial" size="2">Use          Drop table YOUR_TABLE
<strong>cascade</strong></font></div><div> </div><div><fontcolor="#000000">Jhon Carrillo<br /> Ingeniero en
Computación<br/></font><font color="#000000">Caracas - Venezuela<br /></font></div><div> </div><div> </div><div>-----
OriginalMessage ----- </div><blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left:
5px;margin-left: 5px; margin-right: 0px;"><div style="background: rgb(228, 228, 228) none repeat scroll 0%;
-moz-background-clip:initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; font-family:
arial;font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal;
font-size-adjust:none; font-stretch: normal;"><b>From:</b> <a href="mailto:Mark.Fenbers@noaa.gov"
title="Mark.Fenbers@noaa.gov">MarkFenbers</a></div><div style="font-family: arial; font-style: normal; font-variant:
normal;font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch:
normal;"><b>To:</b><a href="mailto:pgsql-sql@postgresql.org"
title="pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a></div><divstyle="font-family: arial; font-style: normal;
font-variant:normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch:
normal;"><b>Sent:</b>Friday, May 13, 2005 2:38 PM</div><div style="font-family: arial; font-style: normal;
font-variant:normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch:
normal;"><b>Subject:</b>[SQL] Replacing a table with constraints</div><div><br /></div> I have a table called Counties
whichpartially contains a lot bad data.  By" bad data", I mean some records are missing; some exist and shouldn't; and
somerecords have fields with erroneous information.  However, the majority of the data in the table is accurate.  I
havebuilt/loaded a new table called newCounties with the same structure as Counties, but contains no bad data.  My was 
tocompletely replace the contents of Counties with the contents of newCounties.  The problem is: several other tables
haveForeign Key constraints placed on Counties.  Therefore, Pg will not let me 'DELETE FROM Counties;", nor will it let
me"DROP TABLE Counties;"  <br /><br /> I'm perplexed.  Can someone suggest how I can best get data from Counties to
lookjust like newCounties?<br /><br /> Mark<br /><p><hr /><br /> ---------------------------(end of
broadcast)---------------------------<br/> TIP 8: explain analyze is your friend<br /></blockquote></blockquote>