Re: Posgres Query for Foreign Key Check

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Mar 19, 2015 at 5:49 AM, Ankur Kaushik <ankurk@xxxxxxxxx> wrote:

Hi ,

 

We are in Process of migration our Database from Mysql to Postgres .

 

I want ot know How I can disable foreign key check in posgres just as in MySQL set session foreign_key_checks=0;

 


​Try.​

​ALTER TABLE table_name DISABLE TRIGGER ALL; 

http://www.postgresql.org/docs/9.3/static/sql-altertable.html

---
Regards,
Raghavendra
EnterpriseDB Corporation
 

Regards

Ankur

DBA | Trimax Infrastructure



Disclaimer: This e-mail may contain material that is confidential, privileged and product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender or legal@xxxxxxxxx and delete all copies.


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux