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 1hmzUi-0000fK-He for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2019 11:50:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hmzUg-0003hq-Iz for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2019 11:50:10 +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 1hmzUg-0003ce-7S for pgsql-admin@lists.postgresql.org; Mon, 15 Jul 2019 11:50:10 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hmzUd-0003oJ-IK for pgsql-admin@lists.postgresql.org; Mon, 15 Jul 2019 11:50:09 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 9003EBE0556 for ; Mon, 15 Jul 2019 13:50:03 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at rs.plausibolo.de Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id ptalr6q4Cfpr; Mon, 15 Jul 2019 13:50:01 +0200 (CEST) Received: from [192.168.104.107] (unknown [145.253.118.26]) by rs.plausibolo.de (Postfix) with ESMTPSA id E32BDBE04CF; Mon, 15 Jul 2019 13:50:00 +0200 (CEST) Subject: Re: How do I import a sql file into pgAdmin4 ? To: pgsql-admin@lists.postgresql.org References: <1586344675.694544.1563168420153@mail.yahoo.com> <81AFFC3D-FD7B-4C11-93EE-210A8B1C752D@jakobs.com> <325397478.730265.1563181161656@mail.yahoo.com> From: Holger Jakobs Openpgp: preference=signencrypt Autocrypt: addr=holger@jakobs.com; prefer-encrypt=mutual; keydata= mQGiBEG8IA8RBAC6WqUzEPTjest7MvFca5WlI47EgtKzOy1D1X9gSEmPj0sQrilNGEitY/+Q kPnCvI3odz1XXf/MZQtXwlxJA4lPmx8/K7MqBj9vh0J5jRznpE7l+SBDmmDobIqBAgl6BZvH 1C7e2y72h5T1/plrXonLUGzthqBtsvWl0ogoyTJqiwCg6AOhYX+Xbcl8/AXy4F4qbUq4LXsD /j6yCKRkyleN688y9YpuS5J6/ZZ/OBCM74pa2iNge3GmXn1JeUowF693QFCGHkpswmDIoGhL 5iM6GHj9HFB6rTXW5H3sR1y6ta7vXwoNBGkgiM89B1a/KsLT5L6MZgZ5AV0tj6vxwAsuLixS SDiNVNAd8vp2FfqdLlOgThsgVIwKBACsCzZa1VxpdoNSYnkTOSZhEjZkbWApdneQ2bTxXJgW +fWgVeLiojCp6I1AmQqzwHz8UN1nrsQjH8Rnxt2J/C5H/Ek9jlOFakFQXlPMZw3tNeTA1P3B 3zPyq6hKFPZHFklUquE3gHVjnX9qxSW0xvFirf6xAMCMYWRnCQHRgiXoAbQhSG9sZ2VyIEph a29icyA8aG9sZ2VyQGpha29icy5jb20+iGQEExECACQCGwMGCwkIBwMCAxUCAwMWAgECHgEC F4AFAlZ7KnEFCSeLDWIACgkQileck7MZYbpbxgCgxM54+4qx/sfGwq01x93pWr2QghwAoIfD Of6Uoc43y98+xR5/Iu9Z1RH8uQENBEG8IBAQBACiGkoX8HKCocdCwRdMzc9siDs1w0YNayhT PnK9Ii3wzzS2R9NSyWsPQVyx6hkVfSmK6CE5RzfuDUzrYEgyaV/2vT3JD9Gko+RuFnjeQvVo 8hc19bmBSn95ATki+hFy/68MqpMlsG7YyCluRSpXh2qxlhbh2FzTIQmiEQAR4kFCEwADBQP/ Z1Y6nwoXw/5JmLJLFcvZZlFfn4g9TjyMSwH50/AXqOApccy9JSzoTFY87ItmGkhD0qj18PJB St2uqASGrk2/55XK596RWnoeyL9mzj5r6woDqPNRXIbK85foGVIMRrb/EufgSOP5H6VHybvB PD4CppEw4Q0fRsMCaOcvibkjHoqITwQYEQIADwIbDAUCVnsqcQUJJ4sNYQAKCRCKV5yTsxlh urunAJ9avyijdRls7l6XPc2cBMys3xu/sgCeOVJE6DzwBBRUd6S6mtf2eG4FPXg= Message-ID: <020095b4-0622-15d5-c1e8-60df44918fc4@jakobs.com> Date: Mon, 15 Jul 2019 13:50:00 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.1 MIME-Version: 1.0 In-Reply-To: <325397478.730265.1563181161656@mail.yahoo.com> Content-Type: multipart/alternative; boundary="------------58600C831E1E44CCD58DFE81" Content-Language: de-DE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------58600C831E1E44CCD58DFE81 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Hi Karen, all frontends ask for a password if the combination of hostname, user, database needs one, unless you save it in the .pgpass or %APPDATA%\postgresql\pgpass.conf file. Your command     psql -U postgres -d mydb -a -f "Filelocation\name" lacks a host to connect to. If the database is running on the same system, add the option -h localhost. Using the username postgres is generally not a good idea, set up an ordinary user, create a database for that user and use those. The name of the user and database may be identical, but doesn't have to. After downloading PostgreSQL (if for Windows, it should be the one by EDB) it has to be installed. I don't think there is a pure client installer available for Windows, though. Regards, Holger Am 15.07.19 um 10:59 schrieb Karen Goh: > > > > 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 10 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: > > > 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 what 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.  \. > > > > 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.  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 > > > -- > Holger Jakobs, Bergisch Gladbach > +49 178 9759012 > - sent from mobile, therefore short - > > -- Holger Jakobs, Bergisch Gladbach instant messaging: xmpp:holger@jakobs.com +49 178 9759012 oder +49 2202 817157 --------------58600C831E1E44CCD58DFE81 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

Hi Karen,

all frontends ask for a password if the combination of hostname, user, database needs one, unless you save it in the .pgpass or %APPDATA%\postgresql\pgpass.conf file.

Your command

    psql -U postgres -d mydb -a -f "Filelocation\name"

lacks a host to connect to. If the database is running on the same system, add the option -h localhost.

Using the username postgres is generally not a good idea, set up an ordinary user, create a database for that user and use those. The name of the user and database may be identical, but doesn't have to.

After downloading PostgreSQL (if for Windows, it should be the one by EDB) it has to be installed. I don't think there is a pure client installer available for Windows, though.

Regards,

Holger

Am 15.07.19 um 10:59 schrieb Karen Goh:



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 10 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 <holger@jakobs.com> wrote:


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 what 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.  \.



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 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


--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -


--

Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@jakobs.com
+49 178 9759012 oder +49 2202 817157

--------------58600C831E1E44CCD58DFE81--