Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YYQwi-0001OZ-Ge for pgsql-admin@arkaria.postgresql.org; Thu, 19 Mar 2015 03:16:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YYQwh-0000yx-Ky for pgsql-admin@arkaria.postgresql.org; Thu, 19 Mar 2015 03:16:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YYOC3-0004Gp-8Y for pgsql-admin@postgresql.org; Thu, 19 Mar 2015 00:20:11 +0000 Received: from [180.92.167.2] (helo=trimax.in) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YYOBx-0005Yt-VD for pgsql-admin@postgresql.org; Thu, 19 Mar 2015 00:20:09 +0000 Received: from Internal Mail-Server by HMC-Gateway1 (envelope-from ankurk@trimax.in) with ESMTPA; 19 Mar 2015 05:49:57 +0530 From: "Ankur Kaushik" To: Subject: Posgres Query for Foreign Key Check Date: Thu, 19 Mar 2015 05:49:52 +0530 Message-ID: <000001d061da$6d0567e0$471037a0$@trimax.in> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01D06208.86BDF200" X-Mailer: Microsoft Outlook 15.0 Thread-Index: AdBh2ULF65sdcxlFRb6xwWK5CpbC5w== Content-Language: en-in X-Host-Lookup-Failed: Reverse DNS lookup failed for 180.92.167.2 (failed) X-Pg-Spam-Score: 1.6 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_0001_01D06208.86BDF200 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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; 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@trimax.in and delete all copies. ------=_NextPart_000_0001_01D06208.86BDF200 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <=21--=5Bif gte mso 9=5D> <=21=5Bendif=5D--><=21--=5Bif gte mso 9=5D> <=21=5Bendif=5D-->

Hi ,

 

<= p class=3DMsoNormal>We are in Process of migration our Database from Mysql = to Postgres .

 

I want ot know How I can disable foreign key check in posgr= es just as in MySQL set session foreign_key_checks=3D0;

 

Regards

Ankur

DBA =7C= Trimax Infrastructure



Disclaimer: This e-mail may contain material that is confidential, privi= leged and product for the sole use of the intended recipient. Any review, r= eliance or distribution by others or forwarding without express permission = is strictly prohibited. If you are not the intended recipient, please con= tact the sender or legal=40trimax.in and delete all copies.
------=_NextPart_000_0001_01D06208.86BDF200--