I am connected to the postgres database, we have two databases, each of which includes several schemas – ‘clients’ database and ‘products’ database. When i try to write a simple select * limit 100 from the ‘clients’ database, get an error cross-database references are not implemented: "clients.raw_metrica.raw_orders".

In the meantime, I can specify only the schema and table names from the second database and everything works.

I’ve checked several similar questions here, but none of them fit my case. I don’t have capital letters in the name of schemas and databases.
How can I fix this?

select * from clients.raw_metrica.raw_orders limit 100;