Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to use pgadmin 4

How to use pgadmin 4

From
Ajay Kumar
Date:
Hi,

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.
Is there any docs using the pgamin 4 tool or do we have Toad like tool which I have been using for Oracle?

Thanks and Regards,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


Re: How to use pgadmin 4

From
Stephen Frost
Date:
Greetings!

* Ajay Kumar (KUMARAJ@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.
Iwant 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

Re: How to use pgadmin 4

From
Murtuza Zabuawala
Date:
Hello,

You can use query tool.



On Sat, 18 Jul 2020, 02:21 Ajay Kumar, <KUMARAJ@pwcs.edu> wrote:
Hi,

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.
Is there any docs using the pgamin 4 tool or do we have Toad like tool which I have been using for Oracle?

Thanks and Regards,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


Re: How to use pgadmin 4

From
Ajay Kumar
Date:
Hello,

I am using version 4.21 and by default it opens in IE. The message says that it does not support IE 11. How can I open it in Chrome?
When I right click a schema, go to query builder and open a sql file in the editor, the content open like the following:



C
R
E
A
T
E
 
T
A
B
L
E
 
How can I fix it? 

Thanks,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Sent: Saturday, July 18, 2020 1:36 AM
To: Ajay Kumar <KUMARAJ@pwcs.edu>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hello,

You can use query tool.



On Sat, 18 Jul 2020, 02:21 Ajay Kumar, <KUMARAJ@pwcs.edu> wrote:
Hi,

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.
Is there any docs using the pgamin 4 tool or do we have Toad like tool which I have been using for Oracle?

Thanks and Regards,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


Re: How to use pgadmin 4

From
Jack Royal-Gordon
Date:
I expect that someone who has Windows will answer this, but in the meantime, pgAdmin has a configuration utility, and you can configure the command line to use to start it up (at least in Mac OS X you can, and I assume Windows is the same). So figure out the correct command line for Chrome and substitute that for the default.

On Jul 21, 2020, at 8:46 AM, Ajay Kumar <KUMARAJ@pwcs.edu> wrote:

Hello,

I am using version 4.21 and by default it opens in IE. The message says that it does not support IE 11. How can I open it in Chrome?
When I right click a schema, go to query builder and open a sql file in the editor, the content open like the following:



C
R
E
A
T
E
 
T
A
B
L
E
 
How can I fix it? 

Thanks,
Ajay

Ajay Kumar
Applications Developer
Prince William County Public Schools

From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Sent: Saturday, July 18, 2020 1:36 AM
To: Ajay Kumar <KUMARAJ@pwcs.edu>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hello,

You can use query tool.



On Sat, 18 Jul 2020, 02:21 Ajay Kumar, <KUMARAJ@pwcs.edu> wrote:
Hi,

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.
Is there any docs using the pgamin 4 tool or do we have Toad like tool which I have been using for Oracle?

Thanks and Regards,
Ajay

Ajay Kumar
Applications Developer
Prince William County Public Schools

Re: How to use pgadmin 4

From
"R.R. PRAVEEN RAJA"
Date:
Hi Ajay,

You can use Microsoft Edge (build with chromium) and Firefox.

To change from IE to Edge or Firefox change in default programs in control panel.

If you don't want to use browser based pgadmin then you can download pgadmin4 v2.1.

Regards
Praveenraja

Sent from Outlook Mobile

From: Ajay Kumar <KUMARAJ@pwcs.edu>
Sent: Tuesday, 21 July, 2020, 10:46 pm
To: Murtuza Zabuawala
Cc: pgAdmin Support
Subject: Re: How to use pgadmin 4

Hello,

I am using version 4.21 and by default it opens in IE. The message says that it does not support IE 11. How can I open it in Chrome?
When I right click a schema, go to query builder and open a sql file in the editor, the content open like the following:



C
R
E
A
T
E
 
T
A
B
L
E
 
How can I fix it? 

Thanks,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Sent: Saturday, July 18, 2020 1:36 AM
To: Ajay Kumar <KUMARAJ@pwcs.edu>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hello,

You can use query tool.



On Sat, 18 Jul 2020, 02:21 Ajay Kumar, <KUMARAJ@pwcs.edu> wrote:
Hi,

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.
Is there any docs using the pgamin 4 tool or do we have Toad like tool which I have been using for Oracle?

Thanks and Regards,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools



Re: How to use pgadmin 4

From
Ajay Kumar
Date:
Thanks Praveenraja!! It worked. 
I would like to have Desktop version. How can Invoke that?

Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: R.R. PRAVEEN RAJA <rrpraveenraja@live.com>
Sent: Tuesday, July 21, 2020 1:48 PM
To: Ajay Kumar <KUMARAJ@pwcs.edu>; Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hi Ajay,

You can use Microsoft Edge (build with chromium) and Firefox.

To change from IE to Edge or Firefox change in default programs in control panel.

If you don't want to use browser based pgadmin then you can download pgadmin4 v2.1.

Regards
Praveenraja

Sent from Outlook Mobile

From: Ajay Kumar <KUMARAJ@pwcs.edu>
Sent: Tuesday, 21 July, 2020, 10:46 pm
To: Murtuza Zabuawala
Cc: pgAdmin Support
Subject: Re: How to use pgadmin 4

Hello,

I am using version 4.21 and by default it opens in IE. The message says that it does not support IE 11. How can I open it in Chrome?
When I right click a schema, go to query builder and open a sql file in the editor, the content open like the following:



C
R
E
A
T
E
 
T
A
B
L
E
 
How can I fix it? 

Thanks,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Sent: Saturday, July 18, 2020 1:36 AM
To: Ajay Kumar <KUMARAJ@pwcs.edu>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hello,

You can use query tool.



On Sat, 18 Jul 2020, 02:21 Ajay Kumar, <KUMARAJ@pwcs.edu> wrote:
Hi,

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.
Is there any docs using the pgamin 4 tool or do we have Toad like tool which I have been using for Oracle?

Thanks and Regards,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools



Re: How to use pgadmin 4

From
"R.R. PRAVEEN RAJA"
Date:
Hi Ajay,

In pgadmin4 browser-based version we can enable Desktop mode and Server mode. If you want to have GUI based (Non-Browser based version) then you can download from below link.


Regards,
PraveenRaja

From: Ajay Kumar <KUMARAJ@pwcs.edu>
Sent: Wednesday, July 22, 2020 12:19 AM
To: R.R. PRAVEEN RAJA <rrpraveenraja@live.com>; Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Thanks Praveenraja!! It worked. 
I would like to have Desktop version. How can Invoke that?

Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: R.R. PRAVEEN RAJA <rrpraveenraja@live.com>
Sent: Tuesday, July 21, 2020 1:48 PM
To: Ajay Kumar <KUMARAJ@pwcs.edu>; Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hi Ajay,

You can use Microsoft Edge (build with chromium) and Firefox.

To change from IE to Edge or Firefox change in default programs in control panel.

If you don't want to use browser based pgadmin then you can download pgadmin4 v2.1.

Regards
Praveenraja

Sent from Outlook Mobile

From: Ajay Kumar <KUMARAJ@pwcs.edu>
Sent: Tuesday, 21 July, 2020, 10:46 pm
To: Murtuza Zabuawala
Cc: pgAdmin Support
Subject: Re: How to use pgadmin 4

Hello,

I am using version 4.21 and by default it opens in IE. The message says that it does not support IE 11. How can I open it in Chrome?
When I right click a schema, go to query builder and open a sql file in the editor, the content open like the following:



C
R
E
A
T
E
 
T
A
B
L
E
 
How can I fix it? 

Thanks,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Sent: Saturday, July 18, 2020 1:36 AM
To: Ajay Kumar <KUMARAJ@pwcs.edu>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hello,

You can use query tool.



On Sat, 18 Jul 2020, 02:21 Ajay Kumar, <KUMARAJ@pwcs.edu> wrote:
Hi,

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.
Is there any docs using the pgamin 4 tool or do we have Toad like tool which I have been using for Oracle?

Thanks and Regards,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools



Re: How to use pgadmin 4

From
Ashesh Vashi
Date:
On Wed, Jul 22, 2020 at 8:38 AM R.R. PRAVEEN RAJA <rrpraveenraja@live.com> wrote:
Hi Ajay,

In pgadmin4 browser-based version we can enable Desktop mode and Server mode. If you want to have GUI based (Non-Browser based version) then you can download from below link.

That's a very old pgAdmin.
The Latest pgAdmin has a lot of bug fixes, and performance enhancements.

I would not advise downloading that.
Rather - please follow these links for changing the browser to use with pgAdmin.


--
Thanks & Regards,

Ashesh Vashi



Regards,
PraveenRaja

From: Ajay Kumar <KUMARAJ@pwcs.edu>
Sent: Wednesday, July 22, 2020 12:19 AM
To: R.R. PRAVEEN RAJA <rrpraveenraja@live.com>; Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Thanks Praveenraja!! It worked. 
I would like to have Desktop version. How can Invoke that?

Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: R.R. PRAVEEN RAJA <rrpraveenraja@live.com>
Sent: Tuesday, July 21, 2020 1:48 PM
To: Ajay Kumar <KUMARAJ@pwcs.edu>; Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hi Ajay,

You can use Microsoft Edge (build with chromium) and Firefox.

To change from IE to Edge or Firefox change in default programs in control panel.

If you don't want to use browser based pgadmin then you can download pgadmin4 v2.1.

Regards
Praveenraja

Sent from Outlook Mobile

From: Ajay Kumar <KUMARAJ@pwcs.edu>
Sent: Tuesday, 21 July, 2020, 10:46 pm
To: Murtuza Zabuawala
Cc: pgAdmin Support
Subject: Re: How to use pgadmin 4

Hello,

I am using version 4.21 and by default it opens in IE. The message says that it does not support IE 11. How can I open it in Chrome?
When I right click a schema, go to query builder and open a sql file in the editor, the content open like the following:



C
R
E
A
T
E
 
T
A
B
L
E
 
How can I fix it? 

Thanks,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Sent: Saturday, July 18, 2020 1:36 AM
To: Ajay Kumar <KUMARAJ@pwcs.edu>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hello,

You can use query tool.



On Sat, 18 Jul 2020, 02:21 Ajay Kumar, <KUMARAJ@pwcs.edu> wrote:
Hi,

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.
Is there any docs using the pgamin 4 tool or do we have Toad like tool which I have been using for Oracle?

Thanks and Regards,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools



Re: How to use pgadmin 4

From
"R.R. PRAVEEN RAJA"
Date:
Thank You Ashesh 



Regards,
PraveenRaja

From: Ashesh Vashi <ashesh.vashi@enterprisedb.com>
Sent: Wednesday, July 22, 2020 8:45 AM
To: R.R. PRAVEEN RAJA <rrpraveenraja@live.com>
Cc: Ajay Kumar <KUMARAJ@pwcs.edu>; pgAdmin Support <pgadmin-support@postgresql.org>; Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Subject: Re: How to use pgadmin 4
 
On Wed, Jul 22, 2020 at 8:38 AM R.R. PRAVEEN RAJA <rrpraveenraja@live.com> wrote:
Hi Ajay,

In pgadmin4 browser-based version we can enable Desktop mode and Server mode. If you want to have GUI based (Non-Browser based version) then you can download from below link.

That's a very old pgAdmin.
The Latest pgAdmin has a lot of bug fixes, and performance enhancements.

I would not advise downloading that.
Rather - please follow these links for changing the browser to use with pgAdmin.


--
Thanks & Regards,

Ashesh Vashi



Regards,
PraveenRaja

From: Ajay Kumar <KUMARAJ@pwcs.edu>
Sent: Wednesday, July 22, 2020 12:19 AM
To: R.R. PRAVEEN RAJA <rrpraveenraja@live.com>; Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Thanks Praveenraja!! It worked. 
I would like to have Desktop version. How can Invoke that?

Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: R.R. PRAVEEN RAJA <rrpraveenraja@live.com>
Sent: Tuesday, July 21, 2020 1:48 PM
To: Ajay Kumar <KUMARAJ@pwcs.edu>; Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hi Ajay,

You can use Microsoft Edge (build with chromium) and Firefox.

To change from IE to Edge or Firefox change in default programs in control panel.

If you don't want to use browser based pgadmin then you can download pgadmin4 v2.1.

Regards
Praveenraja

Sent from Outlook Mobile

From: Ajay Kumar <KUMARAJ@pwcs.edu>
Sent: Tuesday, 21 July, 2020, 10:46 pm
To: Murtuza Zabuawala
Cc: pgAdmin Support
Subject: Re: How to use pgadmin 4

Hello,

I am using version 4.21 and by default it opens in IE. The message says that it does not support IE 11. How can I open it in Chrome?
When I right click a schema, go to query builder and open a sql file in the editor, the content open like the following:



C
R
E
A
T
E
 
T
A
B
L
E
 
How can I fix it? 

Thanks,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools


From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Sent: Saturday, July 18, 2020 1:36 AM
To: Ajay Kumar <KUMARAJ@pwcs.edu>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: How to use pgadmin 4
 
Hello,

You can use query tool.



On Sat, 18 Jul 2020, 02:21 Ajay Kumar, <KUMARAJ@pwcs.edu> wrote:
Hi,

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.
Is there any docs using the pgamin 4 tool or do we have Toad like tool which I have been using for Oracle?

Thanks and Regards,
Ajay

Ajay Kumar

Applications Developer

Prince William County Public Schools



Attachment