How to write data to a PostgreSQL database

[lisam88]

Hi,

I am trying to write some data on LabVIEW and insert it into a local postgreSQL database. I tried to follow the example below (screen shot of example also attached) using format into the string function and system exec.VI:

https://decibel.ni.com/content/docs/DOC-30308

I get an error message stating:

"Error 2 occurred at System Exec.vi. Command was /usr/bin/psql -c "SELECT * FROM test" mydb". Possible reason: LabVIEW memory is full?

I am using postgresql 9.6 and LabVIEW 2016.

Thanks in advance,

Lisa

[Bob_Schor]

It appears that the error code is coming from your Command to read the database.  Have you verified that the database has been installed correctly and it is even possible to execute the Select command?

Try going to a command prompt and typing the following:

• /usr/bin/psql -c "SELECT * FROM demo1" mydb

Did this do something that is "meaningful"?  What do you get from Standard Out and Standard Error?

If this works, try "by hand" the other psql commands.  Let us know the results.

Bob Schor

[lisam88]

Hi thanks for your comment. I managed to get it to execute by finding the actual location of the psql.exe in my c drive. ..

C:/Program Files/PostgreSQL/9.6/bin/psql -c "%s" mydb

However now the psql.exe pops up asking for a password. Any ideas what this could be? or how to prevent the need for a password?

[Bob_Schor]

Now you are asking a PostgreSQL question.  Go to their site and see what they say.

Bob Schor

[Yamaeda]

---

@lisam88 wrote:

Hi thanks for your comment. I managed to get it to execute by finding the actual location of the psql.exe in my c drive. ..

C:/Program Files/PostgreSQL/9.6/bin/psql -c "%s" mydb

However now the psql.exe pops up asking for a password. Any ideas what this could be? or how to prevent the need for a password?

---

I would wager there's something like a -p option for providing a password.

/Y

[lisam88]

 Thanks for your help, it is much appreciated . In the psql guide there are only two options regarding passwords:

• -w is for when there is no password
• -W is to prompt for a password.

There is no option to provide the password as a command line argument because that information is often available to all users, and therefore insecure.

I have a password contained in configuration file .pgpass.conf. Perhaps I can put this into the labview code? Would you know how to do this?