Disabling constraint check

Поиск
Список
Период
Сортировка
От Salomao Domingos
Тема Disabling constraint check
Дата
Msg-id CA+EvMhv7Tnq-G-hJC3xryMppLCVYCYvfn=f7rtnwj3fcofAKoQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Disabling constraint check
Список 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@f13.com.br 
* * * * * MSN             : salomaodomingos@hotmail.com



В списке pgsql-sql по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: ORDER BY COLUMN_A, (COLUMN_B or COLUMN_C), COLUMN_D
Следующее
От: "Oliveiros d'Azevedo Cristina"
Дата:
Сообщение: Re: Disabling constraint check