Have you tried this ALTER TABLE table_name DROP CONSTRAINT constraint_name; Best, Oliveiros
----- Original Message ----- From: "Salomao Domingos" <salomaodomin...@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: salomaodomin...@f13.com.br * * * * * MSN : salomaodomin...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql