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?
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.vashi@enterprisedb.com>
Sent: Sunday, July 26, 2020 3:30 AM
To: Ajay Kumar <KUMARAJ@pwcs.edu>
Cc: pgadmin-support@postgresql.org
Subject: Re: Schema related
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:
Ajay Kumar
Applications Developer
Prince William County Public Schools
--