Re: Schema related

On Tue, Jul 28, 2020 at 8:32 PM Ajay Kumar <KUMARAJ(at)pwcs(dot)edu> wrote:

> Ashesh,
>
>
>
> The document was very helpful and it worked.
>
> Once I use INSERT or COPY command in the ora2pg to generate the sql file,
> it came as huge file of more than 10gb which makes the pgadmin editor to
> hang. What is the best practice? Is there a way to insert the data from
> this generated file without opening the file in the editor?
>
10 GB is definitely a very huge file.
I would suggest you use psql for this operation.

-- Thanks, Ashesh

> Looks like we can’t do it on a schema level.
>
>
>
> If you point me to a document that will be great.
>
>
>
> Thanks,
>
> Ajay
>
>
>
> Ajay Kumar
>
> Applications Developer
>
> Department of Information Technology
>
> Prince William County Public Schools
>
>
>
> *From:* Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
> *Sent:* Sunday, July 26, 2020 3:30 AM
> *To:* Ajay Kumar <KUMARAJ(at)pwcs(dot)edu>
> *Cc:* pgadmin-support(at)postgresql(dot)org
> *Subject:* 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>
>