On Tue, Jul 28, 2020 at 8:32 PM Ajay Kumar <kuma...@pwcs.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.va...@enterprisedb.com> > *Sent:* Sunday, July 26, 2020 3:30 AM > *To:* Ajay Kumar <kuma...@pwcs.edu> > *Cc:* pgadmin-supp...@postgresql.org > *Subject:* Re: Schema related > > > > > > > > On Sat, 25 Jul 2020 at 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. > > 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> >
