Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI - Mailing list pgsql-general

On 12/7/18 12:28 AM, s400t@yahoo.co.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@gmail.com>
>     *To:* Adrian Klaver <adrian.klaver@aklaver.com>; s400t@yahoo.co.jp;
>     "pgsql-general@lists.postgresql.org"
>     <pgsql-general@lists.postgresql.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@yahoo.co.jp <mailto:s400t@yahoo.co.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.klaver@aklaver.com