Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hmtW0-0007qg-N2 for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2019 05:27:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hmtVz-0002vT-IK for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2019 05:27:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hmtVy-0002vK-RG for pgsql-admin@lists.postgresql.org; Mon, 15 Jul 2019 05:27:07 +0000 Received: from sonic304-56.consmr.mail.bf2.yahoo.com ([74.6.128.31]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hmtVw-0007JO-8Z for pgsql-admin@lists.postgresql.org; Mon, 15 Jul 2019 05:27:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1563168420; bh=SiFRuqF1X91uIfsPPZKx2X8XRqpOhPvEhh+aCQS8gPE=; h=Date:From:To:Subject:From:Subject; b=ua1uXQKKeSbBG4+3P5KwIfiDNip9abSU//Vk3w4Hh1hPW/1Humr6UWSE1bLKmFQ48I9x136IusK8NFOA6HSeTSTEQlto4EzFWclvZyE1bSA7PlkTZaheAA/xeOdbYKqq0wS27fIjfz3NTGQ5hZ83Zon4TOeZxy5BNyer8FheSeWbfW8Ss2h8o50jUwp6h+L4SlkaX7uk0J9Od3WguPMKHYMThZmwuM4jfzPtvXDYa8tD3etQgBfWqrevHZOxJHdSTS1AuSlq47FyzkXtZMAKzNR0+EMBxapuqjn4eg4DDswZiXtEFCusjdJ14fdL233Uxt5tkf1yIgoxnk9rDSSH7g== X-YMail-OSG: qHrPn4kVM1myNnFfai6usQhg9FE68m6kZeobJJoMt5cMo5jEa72kXvzv2QivvSc Qi6.W0Q2r2u290evUfkP.7K1ZKdwsBjtM3XvTR_uS38YOO8_IURhJRfZDlLOjKIIxsKfQCg3RY0d 2CeXjMwrdMxG6mJ44azrOS15teR1k_GS3.Q5O67OBhWKk5FW0uItF.vj.N7AvDdd1bDl2usdN8JQ jETZzzW98IzWCQfAoWKl7qXEPG4yFgMNLEDP8LsOD9F56gQy0kDJaw1kTAD1H7FOubT_Q8ndCyw1 xcfxHt4P6XK8hvvlBI_sbcwVYgkcGXTEPAhxFYfSDoOMfepM_smg.q9pi6cp0BGGXQWMLz7DFgRp wcvyZ9d0Zm2x1gbYbiLZXgsIbv3i11GaAt9kkNDw7PsBWA66myaUY2L8DGDnJrflP1Ao2DDaT25p P9Alc.wmAHHQZ2EcQMMS9qHU4JlQ7pYBuDBInX6kHVI2hPRa7dPsPjbVGmm6Y3gCUrBdok9GT7PY qxDR90AdCaUuvlPoNraVcRfBCFqktPHD9UskJKUyndgJkS7EpugsDJsmnsr9BrVFdIlEDCJhatMr 2GEmeVBpAYaihAHjupZPw3b.pNJbtk6AcRcUEospPKpIk1AekDC3vG7mglLiVv1kqNZXl72gABmh z5eVFoqnh3zPrH4U5rCRrBCqlp.xWHqxufGI.xAguRq5BaCmTAwXFNdGer9jnjBz8lotjToDFzES ml0hyJKPSNNYRSDCVCaAdbD756Xyyk1ASP5i4ck.eE4._P3eyx97Gs0XeySEKMhFr8azm4IBDJOX qSJWV1wu1WEKzMx5wGns.as1vfYuaQk6Bjeo5F8EGpBc9NM411dMhxd4Ti8zs9pZlTfI0FiGtXy8 k_RxkSCCvqsAbD4FK79jcjFqAtlocd_S5ul70FM6AIFcreptrGVtKT5kMdisq4h8pg8gdpy4Xe6h NPTDdBVwYumQvcxzDVtmSqG4nRnp1NyGsM8fpjKJahuBzqbkmiEi0qhyMflP7WC4WFWMNNM1iN04 m4D6SV3otn5.8webkxSwqcVACvlLZ.suKbEZnrXY4xwsphWKa89D9GgEn8c76kkygIVbGq_kUxAy e32ugb04S5A67i_QpzUKRTlF7JTZDbS7MUrGEvf7ilTg5qg2HjlKY12xVC1jR01KyxFkXN3J3m36 iNoout8vlsdC26PZgz_OkaK6n6kVYbFUoASegHTNyX2xCpOzkIGOpsESjHXM- Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.bf2.yahoo.com with HTTP; Mon, 15 Jul 2019 05:27:00 +0000 Date: Mon, 15 Jul 2019 05:27:00 +0000 (UTC) From: Karen Goh To: pgsql-admin@lists.postgresql.org Message-ID: <1586344675.694544.1563168420153@mail.yahoo.com> Subject: How do I import a sql file into pgAdmin4 ? MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Length: 339 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, I need to migrate to postgreSQL using SQL flat files which contains a few thousands rows of data. So far, I have attempted but not successful. Not sure if it can't be done using pgAdmin4. And posting to Stackoverflow superUser doesn't help as there is no reply at all. Hence, I hope to get some help here. Thanks & regards, Karen