Re: Programmatic access to the SQL tab of pgadmin

2022-02-21 Thread Ni Ne
I don't have any input, but am eager to know if you are able to solve this. I too am very interested in retrieving the DDL info that pgAdmin provides. If you search the history for this mailing list, I had asked about something similar a month or so ago. Someone had responded with some hints abo

Possible to stop pgAdmin4 from re-formatting my SQL statements in Views and such?

2022-02-18 Thread Ni Ne
I have a syntax format for SQL that I prefer, so when I craft new Views or what-not I write them out a certain way. When I save that SQL into a View, pgAdmin4 will re-format it. If I later need to debug that View, it adds some complexity for me because first I have to re-format the layout in a

SQL query that can be used to generate the same output shown in the SQL tab within pgadmin?

2022-01-11 Thread Ni Ne
My question is not specifically about how to use pgadmin, I hope that's okay. When are you in pgadmin you can select an object from the tree on the left-pane, like a View. While that object is selected, if you click the SQL button in the main-pane toolbar, you can see all SQL commands that were

Re: pgAdmin commandLine

2021-10-22 Thread Ni Ne
Saif, Try first to open a command terminal by typing cmd.exe from the Windows Run prompt. Then from that window execute the psql commands. Get Outlook for Android From: Saif Manai Sent: Friday, October 22, 2021 7:38:07 AM To: Aditya Toshn

pgadmin4 suddenly not working - ImportError: cannot import name 'view_commit'

2021-07-09 Thread Ni Ne
pgadmin4 was previously working, logged in this morning and now it's not. Am guessing an automatic yum update went through. I am running CentOS 7, pgadmin4 5.4, Flask 1.1.2 This is the error I am getting in the apache error_log file: mod_wsgi (pid=14087): Failed to exec Python script file '/

Possible to pre-define connection info on server side?

2021-06-30 Thread Ni Ne
I am using ldap2pg to import users from my domain into postgres as roles, so people can automatically login to pgadmin/postgres using their domain credentials. Is it possible to setup pre-defined connections for a database on the server side? We are using the web-server instance of pgadmin4, ve