Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Karen Goh <karenworld(at)yahoo(dot)com>
Cc: <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Date: 2019-07-16 11:19:28
Message-ID: 87d0ia1bmt.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>>>>> "Karen" == Karen Goh <karenworld(at)yahoo(dot)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?

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Karen Goh 2019-07-16 12:45:49 Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Previous Message Karen Goh 2019-07-16 09:48:55 Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?