Re: [pgadmin-support] making me love pgAdmin III - Mailing list pgadmin-support

From
Subject Re: [pgadmin-support] making me love pgAdmin III
Date
Msg-id 006401d2d3ce$0c46b590$24d420b0$@gmx.us
Whole thread Raw
In response to Re: [pgadmin-support] making me love pgAdmin III  (Christoph Schreiber <schreiber@netzwerge.de>)
List pgadmin-support

Hi Christoph,

 

> sorry I meant to backup a single table (not a column) in a schema. This is possible with pga3 and of course with the pgsql-console but not in pga4.

This is possible. Right click on a table in the browser (structure) and select „Backup…“ from the context menu.

 

It looks like at the moment it is not possible to say “backup database” and select specific tables. But it works for the whole database or specific table.

 

 

Von: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] Im Auftrag von Christoph Schreiber
Gesendet: Dienstag, 23. Mai 2017 15:42
An: pgadmin-support@postgresql.org
Betreff: Re: [pgadmin-support] making me love pgAdmin III

 

Hi Melvin,

 

sorry I meant to backup a single table (not a column) in a schema. This is possible with pga3 and of course with the pgsql-console but not in pga4.

 

Regards, Christoph

 

 

Von: Melvin Davidson [mailto:melvin6925@yahoo.com]
Gesendet: Dienstag, 23.
Mai 2017 15:18
An: Christoph Schreiber <schreiber@netzwerge.de>; PgAdmin Support <pgadmin-support@postgresql.org>
Betreff: Re: [pgadmin-support] making me love pgAdmin III

 

Christopher,

 

I am not PgAdmin support, but in all fairness

>You cannot make a pg_dump from a single column. You always have to dump the whole table.

 

this has never been the case. pg_dump has never had the option to dump just a single column.

 


If you want to "dump" a single column, you must use the COPY TO command.

 

 

 

Melvin Davidson 🎸
    Cell 720-320-0155
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Das Bild wurde vom Absender entfernt.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com

 


From: Christoph Schreiber <schreiber@netzwerge.de>
To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Tuesday, May 23, 2017 3:13 AM
Subject: Re: [pgadmin-support] making me love pgAdmin III

 

Hi Dave,

 

well then I wanna give you a constructive feedback.

My 3 biggest issues with pga4 are

-          It is not working on Win10. If you install it and then e.g. make a dump you don’t see the little pop-up window with the status/error/success message. So I do never know what is happening. And in my opinion a software has to support all modern Windows versions.

-          You cannot make a pg_dump from a single column. You always have to dump the whole table.

-          And the far biggest issue is, that the commit/rollback buttons are missing. I accustom myself to never use the autocommit function for safety reasons. But is there a way in pga4 to commit a query “by hand” like in pga3?

 

These issues make me use pgAdmin3 with the newest version of the pgsql programm so that it is working with a 9.6 database. And it works fine. No crashes. Even the loosing server connection problems seems to be fixed.

 

Regards, Christoph

 

 

Von: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] Im Auftrag von Dave Page
Gesendet: Donnerstag, 18.
Mai 2017 22:43
An: Eric Hill <Eric.Hill@jmp.com>
Cc: pgadmin-support@postgresql.org
Betreff: Re: [pgadmin-support] making me love pgAdmin III

 

 


On 18 May 2017, at 21:09, Eric Hill <
Eric.Hill@jmp.com> wrote:

Hey,

 

I don’t mean to hurt anyone’s feelings or anything, but is it not obvious to everyone that pgAdmin 4 (I have version 1.4) is bloody horrendous?  It is absolutely as slow as Christmas.  It’s use of screen real-estate is poor.  I was never a huge fan of pgAdmin III; I mean, it seemed to do its job okay, but after using pgAdmin 4, suddenly I have newfound respect for pgAdmin III.

 

Not to me, because the number of people I've had complimenting pgAdmin 4 is probably 20x the number who have said they don't like it. Which is a good sign - normally people who don't like something are far more likely to say something.

 

Either way, I'm not going to lose sleep over it. pgAdmin 4 is far more stable than pgAdmin 3 was, has attracted more new developers in a year than pgAdmin 3 had in 15, and continues to improve with every release. I'm very proud of the way the team have built such a complex application in such a short space of time that many people have told me they like.

 

You can't please everyone unfortunately, but then a) it's free (despite being estimated at over $2M worth of work), and b) it's open source so those that are inclined can help improve it further.

 

Constructive feedback is always welcome of course. In your case maybe you could explain how you're using it such that you see slow response. For me, it performs well, even on my low powered 1.2GHz MacBook. It's naturally slower than pgAdmin 3 of course, as it's not a native application, but it still outpaces my ability to drive it and I'm no slouch behind the keyboard.

 

Regards, Dave

 

pgadmin-support by date:

Previous
From: Christoph Schreiber
Date:
Subject: Re: [pgadmin-support] making me love pgAdmin III
Next
From:
Date:
Subject: Re: [pgadmin-support] making me love pgAdmin III