Greetings!

* Ajay Kumar (kuma...@pwcs.edu) wrote:
> I am very new to this tool. Created the database, and one schema. Now I have 
> a sql script generated by ora2ppg tool. I want to run this script using the 
> pgadmin 4 and I want these tables to be created in the new schema I created.

One option is to use the "Query Tool" and then paste into the box the
schema creation script from ora2pg.

Another approach you might consider is using 'psql'.

> Is there any docs using the pgamin 4 tool or do we have Toad like tool which 
> I have been using for Oracle?

I do believe that you can connect to PostgreSQL from Toad.

> Prince William County Public Schools

Very cool to see someone else in Virginia!  I'm in Loudoun myself.
Would love to chat about PWCS using PostgreSQL!

Thanks,

Stephen

Attachment: signature.asc
Description: PGP signature

Reply via email to