In general, when you want to create or access objects in a schema, you need to write a qualified name consisting of the schema name and object name separated by a dot in the query tool as shown below,
SELECT * FROM your_schema_name.table_name;
--
Murtuza
On Sat, 25 Jul 2020, 16:59 Ajay Kumar, <KUMARAJ@pwcs.edu> wrote:
Hi
I have PG12.3 and am using pgadmin4.21.
I created my own schema, right click and went to query tool and tried to create some tables.
When I checked, it created all those tables in PUBLIC schema. How can ceate the same in my own schema which I created? Sorry, I don't find any docs online.
