Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TDh4n-0007GN-TY for pgsql-sql@postgresql.org; Mon, 17 Sep 2012 19:33:49 +0000 Received: from authsmtp08.register.it ([81.88.48.58] helo=authsmtp.register.it) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TDh4m-0000Jn-Ks for pgsql-sql@postgresql.org; Mon, 17 Sep 2012 19:33:49 +0000 Received: (qmail 3595 invoked from network); 17 Sep 2012 19:33:46 -0000 Received: from unknown (HELO Moon) (oliveiros.cristina@asperger-talents.com@95.93.54.178) by authsmtp.register.it with ESMTPA; 17 Sep 2012 19:33:46 -0000 Message-ID: <037A0FA64B8D4068960BA161101B905A@Moon> From: "Oliveiros d'Azevedo Cristina" To: "Salomao Domingos" , References: Subject: Re: Disabling constraint check Date: Mon, 17 Sep 2012 20:33:43 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="UTF-8"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 X-Pg-Spam-Score: 0.4 (/) X-Archive-Number: 201209/45 X-Sequence-Number: 36847 Have you tried this ALTER TABLE table_name DROP CONSTRAINT constraint_name; Best, Oliveiros ----- Original Message ----- From: "Salomao Domingos" To: 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