From: | <s400t(at)yahoo(dot)co(dot)jp> |
---|---|
To: | rob stone <floriparob(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI |
Date: | 2018-12-07 08:28:18 |
Message-ID: | 1078893091.227120.1544171298546.JavaMail.yahoo@mail.yahoo.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Adrian, Rob!
Thank you for the comments.
Oh, yes, I forgot to mention that I am using Postgresql version 9.6.I had read somewhere that last supported version was 9.3 or something, could be 9.2 as you say.
I wanted to use phpPgAdmin, that's why I went back to 9.6 even if I had installed ver. 10 first.But if the phpPgAdmin quotes identifiers by defaults, I will need to look for some other ways.
Strictly speaking, I don't need to use the phpPgAdmin, but I am trying to find a GUI way to upload a file quickly (the file has thousands of records.)
Now, I am using pyDev in Eclipse to insert records, but I need to use a web-based click and upload.
If I could find a php version of my python code that would be great!My Python code:
cur = conn.cursor()
with io.open(fileName,'r',encoding='utf8') as f: next(f) # Skip header row. cur.copy_from(f, tableName, sep='\t') conn.commit()cur.close()f.close()
I have found PHP samples for line by line read and insert, but that will be too slow for me.
Cheers!
----- Original Message -----
From: rob stone <floriparob(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>; s400t(at)yahoo(dot)co(dot)jp; "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Date: 2018/12/7, Fri 16:47
Subject: Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI
Hello,
On Thu, 2018-12-06 at 21:29 -0800, Adrian Klaver wrote:
> On 12/6/18 7:54 PM, s400t(at)yahoo(dot)co(dot)jp wrote:
>
> Most GUI tools I am familiar with quote identifiers by default.
> > How/where can I tell the phpPgAdmin not to add that extra "" around
> > the
> > field name?
>
> I don't know. I have been under the impression that phpPgAdmin was
> no
> longer maintained/in use.
>
> You might have more luck here:
>
> https://sourceforge.net/p/phppgadmin/discussion/115884
>
> >
> > Thanks for reading and suggestions.
>
>
If you look at phppgadmin on sourceforge, the tarball files are all
dated April 15th., 2013.
It appears to have stalled at Postgres version 9.2.
I doubt if it will run on versions 10 or 11.
Cheers,
Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Francesco Nidito | 2018-12-07 11:24:26 | Re: Log level of logical decoding |
Previous Message | rob stone | 2018-12-07 07:47:07 | Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI |