Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

On 12/7/18 12:28 AM, s400t(at)yahoo(dot)co(dot)jp wrote:
> 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.

I don't think the quoted identifiers are the issue. I am suspecting that
the import code may be trying to INSERT into the wrong version of the
table. Some questions:

1) Which schema did you create spec in?

2) In psql what does \d spec show?

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

?
https://www.pgadmin.org/

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com