search

cube2222 / octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Mozilla Public License 2.0
4.74k stars 201 forks source link

couldn't get table from plugin when connect to postgres (private cloud provider) #292

Closed swuecho closed 1 year ago

swuecho commented 1 year ago

Error: typecheck error: couldn't create datasource: couldn't get table from plugin: rpc error: code = Unknown desc = couldn't get table: schema configuration setting is required.

I could connect to the postgres instance using psql.

swuecho commented 1 year ago 
databases:
  - name: mydb
    type: postgres
    config:
      host: localhost
      port: 5443
      database: mydb
      user: postgres
      password: postgres

add: schema: public

problem solved.

cube2222 commented 1 year ago

Hey!

Glad you found the solution! I'll check any documentation to make sure that the schema is mentioned everywhere.