I am connecting to a PostgreSQL database named 'myDB' from MATLAB. When I query this database from the command line, I am able to get results:
>> conn = database('myDB', 'myUsername', 'myPass', 'Vendor', 'PostgreSQL');>> select(conn, 'SELECT * from person')
However, when I try to look at this database in Database Explorer, I get an error:
SELECT * FROM myDB.public.person
"JDBC Driver Error: ERROR: cross-database references are not implemented: "tsdatabase.public.person"
Position: 15"
If I include the database name and schema in my command line query like Database Explorer does, I see the same error:
>> select(conn, 'SELECT * from myDB.public.person')
"Error using database.jdbc.connection/select (line 108)
JDBC Driver Error: ERROR: cross-database references are not implemented: "tsdatabase.public.person"
Position: 15"
I know that this table exists, as I am able to query it without specifying the database name and schema. I also know that the schema is correct, as I have checked the schema using 'sqlfind'. What is causing this error?
Best Answer