Date: Fri, 19 Jul 2019 12:29:39 +0000 (UTC)
From: Karen Goh <karenworld@yahoo.com>
To: pgsql-admin@lists.postgresql.org, Holger Jakobs <holger@jakobs.com>
Message-ID: <1290115266.2200954.1563539379544@mail.yahoo.com>
In-Reply-To: <43c3af86-ec16-ae22-de9f-b01622ab5f44@jakobs.com>
References: <1586344675.694544.1563168420153@mail.yahoo.com>
 <81AFFC3D-FD7B-4C11-93EE-210A8B1C752D@jakobs.com>
 <325397478.730265.1563181161656@mail.yahoo.com>
 <43c3af86-ec16-ae22-de9f-b01622ab5f44@jakobs.com>
Subject: Re: How do I import a sql file into pgAdmin4 ?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2200953_1381539911.1563539379543"
Content-Length: 6543
Precedence: bulk

------=_Part_2200953_1381539911.1563539379543
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

 
On Monday, July 15, 2019, 9:44:24 PM GMT+8, Holger Jakobs <holger@jakobs.com> wrote:


Hi Kargen,

The password is the one which was set for the respective user (here: postgres) in the database backend.

A fresh installation typically has only one user role named postgres. The password is asked for during the installation (in case of Windows). On Linux servers the role has no password, but is authenticated by peer, which means that you connect from a session on the database server locally to the database.

After installing the EDB Postgres database on Windows, you have to start the client programs with their complete path or add the directory where they reside (typically C:\Program Files\Postgresql\versionNumber\bin) to the environment variable %PATH%. Please check with your system administrators on how to do this.


OK. Now I found my password from my notebook.

Using Windows 10 command prompt, the error said it can't find that file but the fileName everything was correct.
Is there anything wrong with that query? 

I also read this thread but I can't find any file open to get pgAdmin4 to open my file.


https://www.postgresql.org/message-id/287946147.391841.1515085145687%40mail.yahoo.com

Please advise.

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
  
------=_Part_2200953_1381539911.1563539379543
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>                <br><br><br><br><br>On Monday, July 15, 2019, 9:44:24 =
PM GMT+8, Holger Jakobs &lt;holger@jakobs.com&gt; wrote:<br><br><br>Hi Karg=
en,<br><br>The password is the one which was set for the respective user (h=
ere: postgres) in the database backend.<br><br>A fresh installation typical=
ly has only one user role named postgres. The password is asked for during =
the installation (in case of Windows). On Linux servers the role has no pas=
sword, but is authenticated by peer, which means that you connect from a se=
ssion on the database server locally to the database.<br><br>After installi=
ng the EDB Postgres database on Windows, you have to start the client progr=
ams with their complete path or add the directory where they reside (typica=
lly C:\Program Files\Postgresql\versionNumber\bin) to the environment varia=
ble %PATH%. Please check with your system administrators on how to do this.=
<br><br><br>OK.  Now I found my password from my notebook.<br><br>Using Win=
dows 10 command prompt, the error said it can&#39;t find that file but the =
fileName everything was correct.<br>Is there anything wrong with that query=
?  <br><br>I also read this thread but I can&#39;t find any file open to ge=
t pgAdmin4 to open my file.<br><br><br>https://www.postgresql.org/message-i=
d/287946147.391841.1515085145687%40mail.yahoo.com<br><br>Please advise.<br>=
<br>Regards,<br><br>Holger<br>Am 15.07.19 um 10:59 schrieb Karen Goh:<br><b=
r><br><br>Hi Hoger,<br><br>I tried as you said. I downloaded this psql - po=
stgres frontend for windows and then tried pg_dump as well as psql command =
prompt.<br><br>But, they asked me for password.<br><br>May I know what kind=
 of password it is referring to ?<br><br>When I downloaded POSTGRESQL, it i=
s saved in the program files in windows 10 but there isn&#39;t any command =
line tool available.<br>I tried using windows 10 command prompt but it is n=
ot accepting any command like I what type :<br>psql -U postgres -d mydb -a =
-f &quot;Filelocation\name&quot;<br><br>Please help.<br><br>Thanks.<br>On M=
onday, July 15, 2019, 1:32:08 PM GMT+8, Holger Jakobs &lt;holger@jakobs.com=
&gt; wrote:<br><br><br>The easiest way would be using psql on the command l=
ine.<br><br>Dump a little database using pg_dump with the option --data-onl=
y to see what the format digestible by psql looks like.<br><br>Basically, i=
t&#39;s a COPY command followed by the data in tab-separated format finishe=
d by a line consisting of a backslash and a period.  \.<br><br><br><br>Am 1=
5. Juli 2019 07:27:00 MESZ schrieb Karen Goh &lt;karenworld@yahoo.com&gt;:<=
br>&gt;Hi,<br>&gt;<br>&gt;I need to migrate to postgreSQL using SQL flat fi=
les which contains a<br>&gt;few thousands rows of data.<br>&gt;<br>&gt;So f=
ar, I have attempted but not successful.  Not sure if it can&#39;t be<br>&g=
t;done using pgAdmin4.<br>&gt;<br>&gt;And posting to Stackoverflow superUse=
r doesn&#39;t help as there is no<br>&gt;reply at all.<br>&gt;<br>&gt;Hence=
, I hope to get some help here.<br>&gt;<br>&gt;Thanks &amp; regards,<br>&gt=
;Karen<br><br><br>-- <br>Holger Jakobs, Bergisch Gladbach<br>+49 178 975901=
2<br>- sent from mobile, therefore short -<br><br><br>-- <br><br>Holger Jak=
obs, Bergisch Gladbach<br>instant messaging: xmpp:holger@jakobs.com<br>+49 =
178 9759012 oder +49 2202 817157<br>            </div>           =20
------=_Part_2200953_1381539911.1563539379543--