From: Oliveiros d'Azevedo Cristina <oliveiros.cristina@asperger-talents.com>
To: Salomao Domingos <salomaodomingos@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Disabling constraint check
Date: Mon, 17 Sep 2012 20:33:43 +0100
Message-ID: <037A0FA64B8D4068960BA161101B905A@Moon> (raw)
References: <CA+EvMhv7Tnq-G-hJC3xryMppLCVYCYvfn=f7rtnwj3fcofAKoQ@mail.gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oliveiros.cristina@asperger-talents.com, salomaodomingos@gmail.com
Subject: Re: Disabling constraint check
In-Reply-To: <037A0FA64B8D4068960BA161101B905A@Moon>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox