Re: Schema related

2020-07-25 Thread Murtuza Zabuawala
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 Kum

Schema related

2020-07-25 Thread Ajay Kumar
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. Tha