| Postgresql connection [message #789] |
Sat, 29 February 2020 14:53  |
polgia
Messages: 2
Registered: February 2020
Location: italy
|
Junior Member |
|
|
Hello,
I am trying to retrive a table from a Postgresql (v12) database installed on a local host. As connecting string, I am using the following : postgresql://127.0.0.1:50036/chemicals
because 127.0.0.1 is my local IP;, 50036 is the port; chemicals is the name of the database. In the SQL string, I put: SELECT * FROM pure_components; because I want to retrive the whole table named "pure_components".
If I use the same parameters, I can connect and retrive the table in python, so it seems they are correct. However, when I use them in Datawarrior via "Run Data from SQl-Database...", the software allows to dial user and password ( I use: postgres and mypassword) but then it freezes. No way to start it again and I have to stop the process. I suppose some parameters are supplied in a wrong way. My setup is quite common in a local installation. Any suggestion?
Thanks
|
|
|
|
Search
Help
Members
Register
Login
Home
