SQL Queries within .m files

Question

Laura Iten 2017-5-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/338881-sql-queries-within-m-files

回答： Laura Iten 2017-5-8

Hey there

I am already connected to my database (Postgres) but would like to send queries directly from my script. Like this:

selectquery = 'SELECT * FROM inventoryTable'; data = select(conn,selectquery)

Since I am already connected, I don't have a "conn" variable saved. How do I get it? I'm using PSQL on Mac OS with a JBDC driver and it works i.e. I am connected. But I would like to integrate queries in my script and save the results directly as a variable.

Alternatively it might also help me if you could tell me how to retrieve the properties I need to execute the "database" function. conn = database(datasource,username,password,driver,url) (I need driver and url). I don't remember what I have now and I don't want to mess up the connection that I can easily set up with the database explorer interface.