Re: Schema related

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, <KUMARAJ(at)pwcs(dot)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
>
>
>
>