On SQuirrelSQL client I have installed the plugin “*UnityJDBC – MultiSource Plugin” that allow multiple sources.
I need to an INSERT or UPDATE on a PostgreSQL, but i alway get an error, even if postgresql source is the only involved.
ExampleExceptionFormatter: exception message was:
org.postgresql.util.PSQLException: ERROR: column “temp_field” of
relation “temp_table” does not exist Position: 30
In the plugin, besides postgresSQL tables I’ve also added a source with an Access db (local mdb file)
AT the moment I can
- execute SELECT queries with fields from both sources.
- execute INSERT queries writing in the access database
*UnityJDBC – MultiSource Plugin is trial and limited to 99 entries