From: | "Muhammad Rusydi" <rusydi(at)cbn(dot)net(dot)id> |
---|---|
To: | "Anand Raman" <araman(at)india-today(dot)com> |
Cc: | "postgres general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: how can i change my table/column constraint |
Date: | 2001-05-05 08:18:37 |
Message-ID: | 003701c0d53c$16167b20$1102a8c0@windows |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Anand,
> basically copy the table to some other table..
> Drop the old table..
> recreate it with the constraints changed
> Repopulate the table..
would you show me with my two tables?
is it like this?
> >if i create another table named lab2 with same fields and then i move
> >all tuples from lab to lab2, then drop table lab and rename lab2 to
> >lab, is the references constraint in table tb2 still valid?
> >would you show me how to do this?
i create lab2 with the same constraint before i delete lab?
isn't it?
after lab2 created i copy all tuples from lab to lab2...
is it right?
what do you repopulate?
sorry...i'm still not getting on to it
TIA
Didi
From | Date | Subject | |
---|---|---|---|
Next Message | Eric G. Miller | 2001-05-05 11:17:21 | Re: how can i change my table/column constraint |
Previous Message | Anand Raman | 2001-05-05 07:18:59 | Re: how can i change my table/column constraint |