Date: Mon, 15 Jul 2019 07:31:29 +0200
User-Agent: K-9 Mail for Android
In-Reply-To: <1586344675.694544.1563168420153@mail.yahoo.com>
References: <1586344675.694544.1563168420153@mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
Subject: Re: How do I import a sql file into pgAdmin4 ?
To: pgsql-admin@lists.postgresql.org
From: Holger Jakobs <holger@jakobs.com>
Message-ID: <81AFFC3D-FD7B-4C11-93EE-210A8B1C752D@jakobs.com>
Precedence: bulk

The easiest way would be using psql on the command line=2E

Dump a little database using pg_dump with the option --data-only to see wh=
at the format digestible by psql looks like=2E

Basically, it's a COPY command followed by the data in tab-separated forma=
t finished by a line consisting of a backslash and a period=2E  \=2E


Am 15=2E Juli 2019 07:27:00 MESZ schrieb Karen Goh <karenworld@yahoo=2Ecom=
>:
>Hi,
>
>I need to migrate to postgreSQL using SQL flat files which contains a
>few thousands rows of data=2E
>
>So far, I have attempted but not successful=2E  Not sure if it can't be
>done using pgAdmin4=2E
>
>And posting to Stackoverflow superUser doesn't help as there is no
>reply at all=2E
>
>Hence, I hope to get some help here=2E
>
>Thanks & regards,
>Karen

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