Hi, 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, <kuma...@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. > > Thanks, > > Ajay Kumar > > Applications Developer > > Prince William County Public Schools > > > >
