| From: | Salomao Domingos <salomaodomingos(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Disabling constraint check |
| Date: | 2012-09-17 18:58:51 |
| Message-ID: | CA+EvMhv7Tnq-G-hJC3xryMppLCVYCYvfn=f7rtnwj3fcofAKoQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 | Oliveiros d'Azevedo Cristina | 2012-09-17 19:33:43 | Re: Disabling constraint check |
| Previous Message | Craig Ringer | 2012-09-17 04:52:46 | Re: ORDER BY COLUMN_A, (COLUMN_B or COLUMN_C), COLUMN_D |