Re: How do I import a sql file into pgAdmin4 ?

Looks like you have additional columns,

Take the file header and created temp table and load to temp to temp table
first.

Create temp table test(< allcolumns list > <text data type >)

On Fri, Jul 19, 2019 at 9:07 AM Karen Goh <karenworld(at)yahoo(dot)com> wrote:

>
>
>
>
>
> On Friday, July 19, 2019, 9:52:42 PM GMT+8, Gopi Setty <gsp06268(at)gmail(dot)com>
> wrote:
>
>
> 1. Simple file import method (Right-click in table and import/export
> option)
>
> image.png
>
> 2. If you are using pg-admin-III right-click on the PSQL consloe option or
> Linux server use a copy command \COPY tmp_test FROM 'test.csv' DELIMITER
> ',' CSV HEADER ;
>
> image.png
>
> Thanks Gopi. However, I am getting the below error.
>
> ERROR: extra data after last expected column
> CONTEXT: COPY dbMembershipparticulars, line 1: "-- phpMyAdmin SQL Dump"
> How do I resolve this error ?
>
> Unfortunately, I am not using Linux server...and just make use of whatever
> iH ave which is Windows 10:(
>
>
>
> On Fri, Jul 19, 2019 at 7:29 AM Karen Goh <karenworld(at)yahoo(dot)com> wrote:
>
>
>
>
>
>
> On Monday, July 15, 2019, 9:44:24 PM GMT+8, Holger Jakobs <
> holger(at)jakobs(dot)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(at)jakobs(dot)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(at)yahoo(dot)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(at)jakobs(dot)com
> +49 178 9759012 oder +49 2202 817157
>
>