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 1hmwpZ-0005ZS-FL for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2019 08:59:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hmwpY-0005Xl-BJ for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2019 08:59:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hmwpX-0005XI-Pw for pgsql-admin@lists.postgresql.org; Mon, 15 Jul 2019 08:59:32 +0000 Received: from sonic316-13.consmr.mail.bf2.yahoo.com ([74.6.130.123]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1hmwpU-0000js-O0 for pgsql-admin@lists.postgresql.org; Mon, 15 Jul 2019 08:59:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1563181166; bh=Mkd1UPM9GA3cCWAexa9MG8svrYoMKe8CHZ0as2xKNRA=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject; b=ZegVTTAEGzXUDrZLu64ynCvqguJqo1lwm13THCSlkh4oEuo7/Y4G8l+wImeo0RpIR2BImaJX/0FwR4Pfsc61+bbBHBRbJbAtq9D4Y2WWrrokTGpz+bavW1OuXE7VI1e5NQAVRUS4KS9+8IdS5fdDUcTAyEqaCHcf9gXaVmiGWfH35vISZ2QCZXhl54kn2od90DYeFq5Er+0UOs0G7DYS76FnLzXJkMqXa4WDpoEclhBScOBJ1GI4koQsnLQXnRFBEEzFmdIUBn/L0iSA6wUWB7MCaZMsEzbmXIs5o3fVXPtxwy9Q6S/GAN7TIHfB/3Y8RIm5gMLXTfg8i81HMUoBiQ== X-YMail-OSG: myCCyKoVM1l.0UUSTtuQ.C9gtZW68BOfLn.PRlhVPjFHGQ1eaIw3otXDiNez5fd qAP0AakFdCGgTcUVXAl1_RBhy0npVdWYoGRJIdhHgfbynPQYdIi1crBqELVdlCPhRlJR6phZcXGS cE2ZIrbBQC8tGZ_SNL5ml1gQkBH8bMO4vqXGO6ThMT9Olm144BjmKIXYM6ba42Nwxc8VumQ5yxrd kVKMNqe0xZJPRX5vgw92H9xN_argFwQ1nvcTSdbS73HwXc_7bIy2fEOdib3T80KOefkeN3SMQLFB HwLFLVqHmeo.3NPqNAGtH3Ili6EI0AI.1LLHSKElsrXZqKqF6rmgAyUPQBQ.UI_mqF1aOLhXzfGg jyYkWhdqIpPGk7AA2GWawCiMpo5NlPEa3aJ7OPxItkqKvWPsRCTyYkUMA4GAdkgGCWE00TGqvphU 3H2ZNrGswf3AhGniCWZUi.ih1izcZhaqo.F.U_1SoEnma56.gOxKKXISM0nmOq.77jz_T2qTnOR4 9yfeM1b0NMzl2DIx1hET6v8fdLZk5ddcehIVmyPXDvmNXmP9Z49fAjV5hGdFW.gOP1DCEWB7ljdr ne.QxoztYX_U6vMKo5T6fNaDqCrB8ytPShvUtfZMqa.LwRRwFTpyd.e9x71IzqK8Dhb_nWfdUY.. wBNuXGRZCK1A8kaudSwgDSGASZRJd__x3v1aFLBhAxcMdMZPXwpQw.H1Z0_It13agrTs256WUfSv 9BGfEW5MRdvEcxBGB._qRBncZlGwLCKnACZko7B_94F8sgT6tKPM.FLvvu9W_eO9Pra94nqm_6ub tKRd50Ida3lUrqUlFMwCWe.6ONmiWF0PuVCpm4tQObwyWfBq6TYACPr9r432skP2M5L3LQAcrTvU dW4kVPqDSq_G7N.tCeA_rjPMgfke0.eUTKHzPeAi3gVv103rcsaLN7RkK_QL_ZrZPlydnsBqeBF. FMSFvz4M4pYckzHbOdQCk0SP1DGlQP8688k5xmi6p2eBNEUqXoki.bOaxpPlNIhHSxPv6AyEz7Lg mKndAhmpV7ukEyU88in4K1FYu9uOSnIKAWs8MrbHK9z4erO_LPRaAJgXqrYFTaXfAgq5YCuzLMz_ T5wSeHFkltJcAg5IU5ckuUlql9utSI7B.tsmhZ3Swvt4_DsTHh16gnWlFkxaKN_WbS0jv6.3dk.O J6tszPLr9bn__Ni2gsu1VpltNztzBC9dPZUrYBUWU2I.AIMUu9ww5gWeLBTBAuH_SMA67v2BIAhz wL7Q- Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Mon, 15 Jul 2019 08:59:26 +0000 Date: Mon, 15 Jul 2019 08:59:21 +0000 (UTC) From: Karen Goh To: pgsql-admin@lists.postgresql.org, Holger Jakobs Message-ID: <325397478.730265.1563181161656@mail.yahoo.com> In-Reply-To: <81AFFC3D-FD7B-4C11-93EE-210A8B1C752D@jakobs.com> References: <1586344675.694544.1563168420153@mail.yahoo.com> <81AFFC3D-FD7B-4C11-93EE-210A8B1C752D@jakobs.com> Subject: Re: How do I import a sql file into pgAdmin4 ? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_730264_1426322014.1563181161654" Content-Length: 4739 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_730264_1426322014.1563181161654 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =20 Hi Hoger, I tried as you said. I downloaded this psql - postgres frontend for windows= and then tried pg_dump as well as psql command prompt. But, they asked me for password. May I know what kind of password it is referring to ? When I downloaded POSTGRESQL, it is saved in the program files in windows 1= 0 but there isn't any command line tool available. I tried using windows 10 command prompt but it is not accepting any command= like I what type : psql -U postgres -d mydb -a -f "Filelocation\name" Please help. Thanks. On Monday, July 15, 2019, 1:32:08 PM GMT+8, Holger Jakobs wrote: =20 =20 The easiest way would be using psql on the command line. Dump a little database using pg_dump with the option --data-only to see wha= t the format digestible by psql looks like. Basically, it's a COPY command followed by the data in tab-separated format= finished by a line consisting of a backslash and a period.=C2=A0 \. Am 15. Juli 2019 07:27:00 MESZ schrieb Karen Goh : >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.=C2=A0 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 --=20 Holger Jakobs, Bergisch Gladbach +49 178 9759012 - sent from mobile, therefore short - =20 ------=_Part_730264_1426322014.1563181161654 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable



Hi Hoger,

I tried as you said. I d= ownloaded this psql - postgres frontend for windows and then tried pg_dump = as well as psql command prompt.

But, they asked me for password.
=
May I know what kind of password it is referring to ?

When I dow= nloaded POSTGRESQL, it is saved in the program files in windows 10 but ther= e isn't any command line tool available.
I tried using windows 10 co= mmand prompt but it is not accepting any command like I what type :
psql= -U postgres -d mydb -a -f "Filelocation\name"

Please help= .

Thanks.
=
On Monday, July 15, 2019, 1:32:08 P= M GMT+8, Holger Jakobs <holger@jakobs.com> wrote:


=
The easiest way would be using psql on the comma= nd line.

Dump a little database using = pg_dump with the option --data-only to see what the format digestible by ps= ql looks like.

Basically, it's a COPY = command followed by the data in tab-separated format finished by a line con= sisting of a backslash and a period.  \.



Am 15. Juli 2019 07:27:00 MESZ schrieb Karen Goh <karenworld@yahoo.com>:
>Hi,>
>I need to migrate to postgreSQL= using SQL flat files which contains a
>few thousands = rows of data.
>
>So far, I have a= ttempted 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.
>
&g= t;Thanks & regards,
>Karen


--
Holger Jakobs, Bergisch Gladbach<= br clear=3D"none">+49 178 9759012
- sent from mobile, the= refore short -


=
------=_Part_730264_1426322014.1563181161654--