Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnLUg-0007kF-Uh for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 11:19:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnLUf-00012F-KY for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 11:19:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnLUf-000124-CR for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 11:19:37 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnLUZ-0000zZ-00 for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 11:19:37 +0000 Received: from [192.168.127.1] (port=35623 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1hnLUX-0000ZA-1r; Tue, 16 Jul 2019 11:19:29 +0000 Received: from [127.0.0.1] (port=11738 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1hnLUW-0000QY-DD; Tue, 16 Jul 2019 11:19:28 +0000 From: Andrew Gierth To: Karen Goh Cc: Subject: Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? In-Reply-To: <2066139407.1119562.1563270535921@mail.yahoo.com> (Karen Goh's message of "Tue, 16 Jul 2019 09:48:55 +0000 (UTC)") Message-ID: <87d0ia1bmt.fsf@news-spur.riddles.org.uk> References: <110414461.528890.1563075361778@mail.yahoo.com> <1846547624.530883.1563075598322@mail.yahoo.com> <40544440.741577.1563178850210@mail.yahoo.com> <768811852.1032981.1563242356010@mail.yahoo.com> <774271584.1091322.1563257675315@mail.yahoo.com> <1984680550.1098414.1563257845450@mail.yahoo.com> <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> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Tue, 16 Jul 2019 12:19:28 +0100 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Karen" == Karen Goh 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)