[SOLVED] What is the difference running a SQL statement on psql and administration tools?

What is the difference running a SQL statement on psql and administration tools?

There is a discrepancy when I run the following SQL statement on different clients:

SELECT 13323::REGCLASS;

OID 13323 in my database belongs to sql_sizing. When I run the query in psql the output is:

           regclass
-------------------------------
 information_schema.sql_sizing

Yet, when I run on the HeidiSQL:

sql_sizing

As you can see in the psql it comes with schema identifier. The problem is thrown for only information_schema. Other schema objects(actually tables, I am working on tables now) do not cause any problem.

The search_path is also same for both of my clients(I am using the same user, postgres):

   search_path
-----------------
 "$user", public

Should it be that HeidiSQL parsing itself or is there a client parameter that I can set the equalize them? What other reasons could cause this problem?

Postgresql version is 15.3.

HeidiSQL version is 12.5.0.6677.

Note: dbfiddle.uk is also reacts as psql

Thanks!

Solution

On the HeidiSQL' s left side dock information_schema was already clicked but on the query tab when I run show search_path it was giving me "$user", public. I disconnected and reconnected from/to database again. Afterwards, I clicked the information schema and run show search_path and got the result, information_schema, "$user", public. It needed a reconnection again.