JD, IB, TL:
Yes!!! I found the whole bunch of tables in template 1!
It's so liberating.
Thank you.
- Original Message -
> From: Tom Lane
> To: s4...@yahoo.co.jp
> Cc: "pgsql-general@lists.postgresql.org"
> Date: 2019/2/28, Thu 17:24
> Subject: Re: Mind of its own?
>
>& lt;s4...
Hopefully not, but I feel so helpless.
What happened?
I am using Postgresql 9.6, and the latest phppgadmin. OS is Debian 9.6.
1. Created a database.
2. Created tables inside that database.
3. Dropped that database.
Now, what happens is when I create another database with the same name or
diff
Hello again Rob,
Thank you for pointing that.
Now what I did:
1. Copied the server.crt created on the postgresqlSERVER's /var/lib/CA/server
directory to client side.
2. Ran this script:|
openssl x509 -in server.crt -out server.crt.der -outform der
3. keytool -keystore $JAVA_HOME/jre/lib/sec
I am having hard time to connect to PostgreSQL server using client certificate
from within a Java program.
Any insight would be helpful.
I can connect to the server using psql command line from a client
machine(192.168.56.101) (psql -h 192.168.56.102 -U user1 -d testdb)
[192.168.56.102 is "post
Hello Rob,
Thank you for your comments.
As I wrote just a few minutes ago, using a tab delimiter inside the implode as
suggested by Daniel (and specifying the read length ("0") for the fgetcsv has
solved this problem.
At one point, I had tried to use the last parameter - enclosure character - i
>and now I can see my data saved in the database without those extra double
>quotes.
.. and with my comma intact as well.
- Original Message -
> From: "s4...@yahoo.co.jp"
> To: Daniel Verite
> Cc: "pgsql-general@lists.postgresql.org"
> Date: 2018/12/18, Tue 14:15
> Subject: Re: Crea
Hello Daniel!
This afternoon, I tried it again, and yes, your suggestion that I use a tab
delimited symbol ("\t") instead of a space for the implode works flawlessly.
Yesterday, I reported I got "Warning: pg_copy_from(): Copy command failed:
ERROR: extra data after last expected..".
That was be
Hi Daniel,
Thank you for the comments.
I changed my line 7 to this:
$line = implode("\t",$line). "\n";
Now, I get the following.
Warning: pg_copy_from(): Copy command failed: ERROR: extra data after last
expected column CONTEXT: COPY test_table, line 1: "1 Denny's orange juice
"1
Hello Good People of the Forum!
I am trying to insert some data into a PostgreSQL database using PHP and
struggling to create an array so that pg_copy_from function will accept and
process the data.
I can insert data but not the way I want- my data this case contains comma,
space, double quotes
To Adrian:Your question: "The original encoding was Win-10 (Japanese)
correct?"Let me answer this way:Yes, I created the file using used Win 10 (J)'s
Excel (2016).When I saved the file as tab delimited text, it seems it was saved
as ANSI because when I opened it using notepad, I could see it was
I didn't specify any schema, so it was created in public schema.The error
message also says
"public"...//--ERROR:
column "rec_id" of relation "spec" does not existLINE 1: INSERT INTO
"public"."spec"
("rec_id","title_c...//--
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 ve
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
13 matches
Mail list logo
