why use phpPgAdmin (was: RE: Importing tab delimited text file using phpPgAdmin 5.1 GUI)

2018-12-13 Thread Kevin Brannen
> From: Tony Shelver > Just a side comment: Why use phpPgAdmin when pgAdmin 4.6 is current, free and > readily available? > It also has a graphical table-from-file loader as well. I can’t speak for the original poster, but there are multiple reasons that might be: * You came from the mysql wor

Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

2018-12-11 Thread s400t
Some version of Excel seem to offer the option to save file with UTF-8 encoding, but the one I am using does not have that option. Time to move ahead. Thanks! - Original Message - From: Adrian Klaver To: s4...@yahoo.co.jp; rob stone ; "pgsql-general@lists.postgresql.org&quo

Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

2018-12-08 Thread Tony Shelver
t; > 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: > >

Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

2018-12-07 Thread Adrian Klaver
# - Original Message - *From:* Adrian Klaver *To:* s4...@yahoo.co.jp; rob stone ; "pgsql-general@lists.postgresql.org" *Date:* 2018/12/7, Fri 23:47 *Subject:* Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI On 12/7/18 12:

Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

2018-12-07 Thread s400t
testdb=# SHOW CLIENT_ENCODING; client_encoding - UTF8(1 row) testdb=# - Original Message - From: Adrian Klaver To: s4...@yahoo.co.jp; rob stone ; "pgsql-general@lists.postgresql.org" Date: 2018/12/7, Fri 23:47 Subject: Re: Importing tab delimited tex

Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

2018-12-07 Thread Adrian Klaver
laver ; s4...@yahoo.co.jp; "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

Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

2018-12-07 Thread s400t
ts.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, s4...@yahoo.co.jp wrote: > > Most GUI tools I am familiar with quote iden

Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

2018-12-06 Thread rob stone
Hello, On Thu, 2018-12-06 at 21:29 -0800, Adrian Klaver wrote: > On 12/6/18 7:54 PM, s4...@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 h

Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

2018-12-06 Thread Adrian Klaver
On 12/6/18 7:54 PM, s4...@yahoo.co.jp wrote: Hello Community! I am trying to use phpPgAdmin  (ver. 5.1 with PHP 5.6.39, server CentOS 7, client Win-10 (Japanese)) to import a tab delimited text file (Excel -> save as tab delimited text;  also used notepad to save the same text file UTF-8 enco

Importing tab delimited text file using phpPgAdmin 5.1 GUI

2018-12-06 Thread s400t
Hello Community! I am trying to use phpPgAdmin  (ver. 5.1 with PHP 5.6.39, server CentOS 7, client Win-10 (Japanese)) to import a tab delimited text file (Excel -> save as tab delimited text;  also used notepad to save the same text file UTF-8 encoding) . Earlier. I had created a table (no colum