From: | "Oliveiros d'Azevedo Cristina" <oliveiros(dot)cristina(at)asperger-talents(dot)com> |
---|---|
To: | "Salomao Domingos" <salomaodomingos(at)gmail(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Disabling constraint check |
Date: | 2012-09-17 19:33:43 |
Message-ID: | 037A0FA64B8D4068960BA161101B905A@Moon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Have you tried this
ALTER TABLE table_name DROP CONSTRAINT constraint_name;
Best,
Oliveiros
----- Original Message -----
From: "Salomao Domingos" <salomaodomingos(at)gmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Sent: Monday, September 17, 2012 7:58 PM
Subject: [SQL] Disabling constraint check
Hi,
I'm need to import data to PostgreSQL via csv file. The database in
question is very problematic and I have that import those data without
checking it. How can I to do that? I know that I can to disable FKs
through "ALTER TABLE table_name DISABLE TRIGGERS ALL", however how can
I disabling CHECK CONSTRAINT too?
--
* Salomão Domingos
* * Analista de Suporte
* * * Linux Professional Institute Certificate 2 - LPIC2
* * * * e-mail comercial: salomaodomingos(at)f13(dot)com(dot)br
* * * * * MSN : salomaodomingos(at)hotmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma | 2012-09-17 20:42:31 | Re: Disabling constraint check |
Previous Message | Salomao Domingos | 2012-09-17 18:58:51 | Disabling constraint check |