Can we join two tables in postgresql if both tables are in different schemas

Question

Do I have one table in a public schema and a second table in a deepak schema, and both schemas are in the same database with any help?

Answer 1

Of course, just use their fully qualified names public.t1 JOIN deepak.t2 USING (col).

Answer 2

Yes, you are just adding a schema.

public.table
deepak.table