Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres schema support #412

Open
ashishkumarazuga opened this issue Sep 15, 2022 · 2 comments
Open

Postgres schema support #412

ashishkumarazuga opened this issue Sep 15, 2022 · 2 comments
Assignees

Comments

@ashishkumarazuga
Copy link

problem statement
The current postgres connector can not import data from a table which is under a schema. The tables are listed but can not be imported.

Describe the solution you'd like
An extra field in the server JDBC configuration defining the schema name could help setting the schema context and fetching the data.

Describe alternatives you've considered
Alternative could be a dynamic feature where it can read data from all schemas.

@ashishkumarazuga
Copy link
Author

@prasser I think the current implementation do have support, but it is hindered by a bug.

Shouldn't this be TABLE_SCHEMA instead of TABLE_SCHEM?

String schema = rs.getString("TABLE_SCHEM"); //$NON-NLS-1$

@prasser
Copy link
Collaborator

prasser commented Sep 20, 2022

Thanks for taking such a close look! TABLE_SCHEM is correct and not a bug. There may be a bug, but if there is one, it is somewhere else.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants