Date: Tue, 16 Jul 2019 12:45:49 +0000 (UTC)
From: Karen Goh <karenworld@yahoo.com>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: pgsql-sql@lists.postgresql.org
Message-ID: <1787690642.1167081.1563281149734@mail.yahoo.com>
In-Reply-To: <87d0ia1bmt.fsf@news-spur.riddles.org.uk>
References: <110414461.528890.1563075361778@mail.yahoo.com>
 <1846547624.530883.1563075598322@mail.yahoo.com>
 <CAKFQuwaLmrFiSAOjzcK2-43F-016CZhP5iRpnyzJ0PzsKEgzog@mail.gmail.com>
 <40544440.741577.1563178850210@mail.yahoo.com>
 <CAKFQuwYJsFw9p_qLyashvUmONFZre9OxgEWxDkqdY6-gWB9G7A@mail.gmail.com>
 <768811852.1032981.1563242356010@mail.yahoo.com>
 <CAKFQuwaC_Z24XxjvsSgYPvSNpu+K1Z9_60auVxEpjFQpE5zrFg@mail.gmail.com>
 <774271584.1091322.1563257675315@mail.yahoo.com>
 <1984680550.1098414.1563257845450@mail.yahoo.com>
 <f11f7f05-e3fc-2794-e4ec-4b7144ae56be@stb-datenservice.de>
 <59735533.1068095.1563265280844@mail.yahoo.com>
 <87o91u1idu.fsf@news-spur.riddles.org.uk>
 <1919398337.1106688.1563269115584@mail.yahoo.com>
 <87k1ci1g9u.fsf@news-spur.riddles.org.uk>
 <2066139407.1119562.1563270535921@mail.yahoo.com>
 <87d0ia1bmt.fsf@news-spur.riddles.org.uk>
Subject: Re: how to resolve org.postgresql.util.PSQLException: ERROR:
 operator does not exist: text = integer?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1167080_69369561.1563281149733"
Content-Length: 3742
Precedence: bulk

------=_Part_1167080_69369561.1563281149733
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

 
On Tuesday, July 16, 2019, 7:19:47 PM GMT+8, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:


>>>>> "Karen" == Karen Goh <karenworld@yahoo.com> writes:

Karen> How do you guys use PostgreSQL ? I do not know other ways except
Karen> PGADMIN4.

This isn't relevant to your question - the process of finding the server
log files would be exactly the same even if you were using the "psql"
command-line tool.

Karen> Is there a tutorial I can read up so that my database that I
Karen> have created can be access via PostgreSQL?

This question does not make sense - if you created a database then it is
accessible.

Karen> Last time when my MYSQL was still working, I can just write
Karen> MySQL d something like that but PostGreSQL I examined the bin
Karen> there is not command line tool whatsoever....:(

Every commonly-used packaging of PostgreSQL includes all the
command-line tools. (Remember that pgadmin4 is a _separate project_ from
PostgreSQL itself.)

As far as I can tell, in all of this exchange you have not told us what
operating system(s) you are using, whether you're running the database
server locally or remotely, what version of what packages you installed
(and where you obtained them). How can we give you advice without
knowing any of these details?

OK. I am at my desktop now. Yahoo now has a hide message hence I wasn't able to type like that before.

Do you mind tell me where do I download PostgreSQL? I am using Windows 10 as OS. Something is wrong with my browser...keep jumping off half way...

-- 
Andrew (irc:RhodiumToad)


------=_Part_1167080_69369561.1563281149733
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>                <br><br><br><br><br>On Tuesday, July 16, 2019, 7:19:47=
 PM GMT+8, Andrew Gierth &lt;andrew@tao11.riddles.org.uk&gt; wrote:<br><br>=
<br>&gt;&gt;&gt;&gt;&gt; &quot;Karen&quot; =3D=3D Karen Goh &lt;karenworld@=
yahoo.com&gt; writes:<br><br>Karen&gt; How do you guys use PostgreSQL ? I d=
o not know other ways except<br>Karen&gt; PGADMIN4.<br><br>This isn&#39;t r=
elevant to your question - the process of finding the server<br>log files w=
ould be exactly the same even if you were using the &quot;psql&quot;<br>com=
mand-line tool.<br><br>Karen&gt; Is there a tutorial I can read up so that =
my database that I<br>Karen&gt; have created can be access via PostgreSQL?<=
br><br>This question does not make sense - if you created a database then i=
t is<br>accessible.<br><br>Karen&gt; Last time when my MYSQL was still work=
ing, I can just write<br>Karen&gt; MySQL d something like that but PostGreS=
QL I examined the bin<br>Karen&gt; there is not command line tool whatsoeve=
r....:(<br><br>Every commonly-used packaging of PostgreSQL includes all the=
<br>command-line tools. (Remember that pgadmin4 is a _separate project_ fro=
m<br>PostgreSQL itself.)<br><br>As far as I can tell, in all of this exchan=
ge you have not told us what<br>operating system(s) you are using, whether =
you&#39;re running the database<br>server locally or remotely, what version=
 of what packages you installed<br>(and where you obtained them). How can w=
e give you advice without<br>knowing any of these details?<br><br>OK.  I am=
 at my desktop now.  Yahoo now has a hide message hence I wasn&#39;t able t=
o type like that before.<br><br>Do you mind tell me where do I download Pos=
tgreSQL? I am using Windows 10 as OS. Something is wrong with my browser...=
keep jumping off half way...<br><br>-- <br>Andrew (irc:RhodiumToad)<br><br>=
<br>            </div>           =20
------=_Part_1167080_69369561.1563281149733--