Thread: 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@f13.com.br 
* * * * * MSN             : salomaodomingos@hotmail.com

Have you tried this

ALTER TABLE table_name DROP CONSTRAINT constraint_name;
Best,
Oliveiros

----- Original Message ----- 
From: "Salomao Domingos" <salomaodomingos@gmail.com>
To: <pgsql-sql@postgresql.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@f13.com.br
 
* * * * * MSN             : salomaodomingos@hotmail.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql