Re: Schema related

On Sat, 25 Jul 2020 at 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.
>
You can use the search path for the same.

Please refer search_path in this documentation:
https://www.postgresql.org/docs/9.6/ddl-schemas.html

— Ashesh

>
> Thanks,
>
> Ajay Kumar
>
> Applications Developer
>
> Prince William County Public Schools
>
>
>
> --

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com>

*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>