Re: Wrong description in backup docs

2019-11-12 Thread Michel Feinstein
12-Nov-2019, at 3:29 PM, Dave Page wrote: > > Hi Abhilasha, > > Can you fix this and check for any related inconsistencies seeing as > you're already working on the other issue we just discussed? > > Thanks! > > On Mon, Nov 11, 2019 at 10:54 PM Michel Feinstein < > mic

Wrong description in backup docs

2019-11-11 Thread Michel Feinstein
The backup docs at: https://www.pgadmin.org/docs/pgadmin4/4.14/backup_dialog.html say: "Move the switch next to *$ quoting* to the* Yes position to enable* dollar quoting within function bodies; if disabled, the function body will be quoted using SQL standard string syntax.". But those are the

Re: Database Backup

2019-11-08 Thread Michel Feinstein
the pg_dump > <https://www.postgresql.org/docs/current/app-pgdump.html> > documentation if you require any specific details on backup process. > > > -- > Regards, > Murtuza Zabuawala > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company &

Database Backup

2019-11-07 Thread Michel Feinstein
Hi guys, I am about to take down a database, so I want to make a backup before, in case I need to turn it on again in the future. Are there any caveats I should be aware of, when using pgAdmin for the backup? Thanks in advance.

Re: joining tables

2019-09-03 Thread Michel Feinstein
Also, be aware that this is NOT the postgresql email list, but the pgAdmin email list, you would get a lot more help about SQL there. On Tue, Sep 3, 2019, 19:44 Jack Royal-Gordon wrote: > Let me step back a bit, as I realize upon further reflection that the > first method will not work. > > As

Re: Is it possible to delete records in the result?

2019-08-11 Thread Michel Feinstein
You can, click the record, not a cell, but the record itself, like a leftmost click, then click the trash can, than click to save. On Sun, Aug 11, 2019, 13:19 wrote: > This is something that always drove me to insanity with the old pgAdmin > III: that once you had made a SELECT query and got a

Re: Visual clutter in default view when viewing table data

2019-08-09 Thread Michel Feinstein
8f8f8; } > > I'm not suggesting that's that's a sensible user work-around, I'm just > pointing out that that's how simple it would be... just add the above > line to the .CSS file. > > Cheers, > Dave > > > On Fri, Aug 9, 2019 at 9:39 AM Michel Feinstein > wrot

Re: Visual clutter in default view when viewing table data

2019-08-09 Thread Michel Feinstein
One thing that helps with readability is intercalating the colors of the table lines (white, light gray, white, light gray). That would be a very nice addition. On Fri, Aug 9, 2019, 09:17 Luther Goh Lu Feng wrote: > > > Thanks for the note. I have created >

Re: Opening pgAdmin 4 in a new browser window as an alternative user flow

2019-08-08 Thread Michel Feinstein
rt of secret key > exchange and context menus. > > On Fri, Aug 9, 2019 at 10:13 AM Michel Feinstein < > michelfeinst...@gmail.com> wrote: > >> I think this would be a lot easier, as you are just basically wrapping a >> browser with a fixed URL address. >&g

Re: Opening pgAdmin 4 in a new browser window as an alternative user flow

2019-08-08 Thread Michel Feinstein
I think this would be a lot easier, as you are just basically wrapping a browser with a fixed URL address. On Fri, Aug 9, 2019, 01:39 Avin Kavish wrote: > The people who want it don't want a browser window, they want an > independent standalone application that is not affected by what they

Re: Appreciation for pgAdmin 4's progress

2019-07-30 Thread Michel Feinstein
I always have one hand at the mouse and one at the keyboard, once I select stuff with the mouse, I hit cntrl+c with the other hand, it's a lot quicker. At least if you don't have any disabilities or are left handed, ctrl+c is at the bottom right corner, where my left hand already rests. On Tue,

Re: pgadmin4 - Use classic style interface, don't launch browser?

2019-07-29 Thread Michel Feinstein
I believe Firefox doesn't use one process per tab, but does use multi-process on its own way. On Tue, Jul 30, 2019, 00:08 Darren Duncan wrote: > Yes, every modern browser uses a separate process per browser tab. > Besides the > mentioned Firefox and Chrome, Safari also does it. So generally a

Re: pgadmin4 - Use classic style interface, don't launch browser?

2019-07-29 Thread Michel Feinstein
Also, I run Firefox with 4 windows, each one with hundreds of tabs (I have easily 500+ tabs in total), I don't restart Windows 10 for months and I don't have any issues here. On Tue, Jul 30, 2019, 00:03 Avin Kavish wrote: > Hey Mark, > > I find this hard to believe as chrome uses process

Re: Please give pgAdmin 4 its own GUI. The constant password inputs are driving me insane...

2019-07-25 Thread Michel Feinstein
Avin, There's a lengthy explanation about the vulnerabilies around the Master Password, solution, if you can't find it on the list, please let me know. In a nutshell, a malware downloaded into a machine (or a malicious browser extension) could search for pgAdmin passwords and steal them. Many

Re: save SQL in PgAdmin4

2019-07-18 Thread Michel Feinstein
In that case I would say you need a "Save as..." button, whereas the "Save" button will track changes and only save if there are any changes. On Thu, Jul 18, 2019, 11:42 Michael Shapiro wrote: > Dave, > > I'd like to make a feature request that PgAdmin4 add a save button (that > is always

Autocomplete

2019-06-28 Thread Michel Feinstein
Is it there any reasons for autocomplete not to work? I am trying Cntrl+Space on Windows 10, pgAdmin 4.6 and it just ignores it completely.

Re: How to close pgAdmin4

2019-06-27 Thread Michel Feinstein
My pleasure, I am not a big fan of this either... But many applications have this behavior, so I am kinda used to it. On Thu, Jun 27, 2019, 11:34 George Weaver wrote: > Hi Michel, > > Thanks! > > (One more inconvenient thing about pgAdmin4.) > > George > On 27/0

Re: [EXTERNAL] - Re: How to close pgAdmin4

2019-06-27 Thread Michel Feinstein
> > *From:* Michel Feinstein > *Sent:* Thursday, June 27, 2019 10:11 AM > *To:* Michelle Schwan > *Cc:* richard coleman ; George Weaver < > gwea...@shaw.ca>; pgAdmin Support > *Subject:* Re: [EXTERNAL] - Re: How to close pgAdmin4 > > > > Google "windows s

Re: [EXTERNAL] - Re: How to close pgAdmin4

2019-06-27 Thread Michel Feinstein
[image: image.png] The last one at the bottom, I am still at pgAdmin 4.6 though. On Thu, Jun 27, 2019 at 10:58 AM Michelle Schwan wrote: > Could you show a screen shot of that? I cannot find the option to exit. > > > > *From:* Michel Feinstein > *Sent:* Thursday, Jun

Re: How to close pgAdmin4

2019-06-27 Thread Michel Feinstein
Look for it in the system tray bar, at the lower right corner of the screen, right click it and see the option to exit. On Thu, Jun 27, 2019, 10:42 George Weaver wrote: > Good morning, > > I would like to know how to "really" close pgAdmin4. > > When I close the pgAdmin4 tab or the browser

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-06 Thread Michel Feinstein
hel, > > On Thu, Jun 6, 2019 at 9:15 AM Michel Feinstein > wrote: > >> *(if the malicious actor can steal the file they can also read the key >> from memory)* >> >> As far as I know it's a lot easier for a program to get access to all the >> files in a system (

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-06 Thread Michel Feinstein
*(if the malicious actor can steal the file they can also read the key from memory)* As far as I know it's a lot easier for a program to get access to all the files in a system (specially on Windows) than to dump the memory, as there are memory barriers protected by the OS (and address

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-05 Thread Michel Feinstein
very helpful on your use case. Michel. On Wed, Jun 5, 2019, 14:03 richard coleman wrote: > Michel, > > Thanks for jumping into the conversation. > > On Wed, Jun 5, 2019 at 12:18 PM Michel Feinstein < > michelfeinst...@gmail.com> wrote: > >> Let me just add some

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-04 Thread Michel Feinstein
It would be easier if the system when prompting for the Master Password, had a "I don't want to define a Master Password" or something like that, which would set that config_local.py property automatically. On Tue, Jun 4, 2019, 18:06 Cherio wrote: > Put "MASTER_PASSWORD_REQUIRED = False" line

Re: Can't see my Issue

2019-05-29 Thread Michel Feinstein
Ok, thanks for the clarification. On Wed, May 29, 2019, 11:46 Dave Page wrote: > > > On Wed, May 29, 2019 at 5:57 AM Michel Feinstein < > michelfeinst...@gmail.com> wrote: > >> Hi, >> >> In a previous email I suggested the use of a master password. Now

Re: How to deal with multiple accounts

2019-05-20 Thread Michel Feinstein
> users and roles CAN cross multiple databases. > > > > if you really want segmentation between development and production, > creating > > two different servers might be best. > > > > > > > > Doug Easterbrook > > Arts Management Systems Ltd. >

Re: How to upgrade pgAdmin4

2019-05-20 Thread Michel Feinstein
Sorry but the only thing I can help is about the .asc file. It's used for verify that the .exe you downloaded is the original one, that no one modified it, injected some malware or something like it. It's a digital signature used in PGP. You can search more about it online looking for PGP or GPG.

Re: How to deal with multiple accounts

2019-05-18 Thread Michel Feinstein
gt; *Doug Easterbrook* > *Arts Management Systems Ltd.* > mailto:d...@artsman.com > http://www.artsman.com > Phone (403) 650-1978 > > On May 18, 2019, at 3:19 PM, Michael Shapiro wrote: > > I'd like to know how people do this as well. I have been creating new > Servers f

How to deal with multiple accounts

2019-05-18 Thread Michel Feinstein
Hi guys, I am looking for opinions on how you use pgAdmin for dealing with several accounts. For example, I have an "admin" account with all the privileges for the database and a "restricted" account for my application to use. I also have some other accounts for other purposes and I was looking

Re: pgAdmin can't create Expression Indexes

2019-05-15 Thread Michel Feinstein
Well, Github is a private company, but the vast majority of open-source projects are there now, Microsoft owns it and made a statement about it... I can't imagine this changing, it would be a huge PR nightmare for Microsoft. I am used to have Stackoverflow for questions and Github for issues, but

Re: pgAdmin can't create Expression Indexes

2019-05-15 Thread Michel Feinstein
Yes, this doesn't affect me, but it just seems to be the wrong workflow, but if you guys don't get annoyed about it, then it's fine I guess. On Wed, May 15, 2019, 09:27 Dave Page wrote: > > > On Wed, May 15, 2019 at 1:01 PM Michel Feinstein < > michelfeinst...@gmail.com> wrote

Re: pgAdmin can't create Expression Indexes

2019-05-15 Thread Michel Feinstein
19 at 1:43 AM Aditya Toshniwal < >> aditya.toshni...@enterprisedb.com> wrote: >> >>> Hi, >>> >>> On Wed, May 15, 2019 at 7:46 AM Michel Feinstein < >>> michelfeinst...@gmail.com> wrote: >>> >>>> I can't find a way t

Re: pgAdmin can't create Expression Indexes

2019-05-14 Thread Michel Feinstein
I will...but just to add my 2 cents, it would be a lot better if you guys could move to Github and use their Issue system instead. On Wed, May 15, 2019 at 1:43 AM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi, > > On Wed, May 15, 2019 at 7:46 AM M

pgAdmin can't create Expression Indexes

2019-05-14 Thread Michel Feinstein
I can't find a way to create an Expression Index such as: CREATE UNIQUE INDEX idx_lower_unique ON your_table (lower(the_column)); Am I missing something or does pgAdmin really doesn't support it? Best wishes, Michel.

Re: pgAdmin Saved Password Security

2019-04-17 Thread Michel Feinstein
Wed, Apr 17, 2019 at 7:20 AM Michel Feinstein < > michelfeinst...@gmail.com> wrote: > >> Hi, >> >> I am new to pgAdmin and PostgreSQL. I am configuring a new server >> connection and I can see there's an option to save my server's password. >> >