We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
CDB_ColumnNames current implementation returns columns for any table matching the name.
When having multiple tables with same name but in a different schema it will report the column name from all the tables.
regclass should be considered when providing qualified table names.
regclass
The text was updated successfully, but these errors were encountered:
SB/6362235
Sorry, something went wrong.
why not using the oid so we don't need to add a filter by schema?
@iriberri CDB_ColumnNames is not public api, ping the user about this.
You are right, actually the signature is CDB_ColumnNames(REGCLASS) so it should be a bugfix more than a new feature as it's already possible to do:
CDB_ColumnNames(REGCLASS)
select CDB_ColumnNames('foo.table_name'); select CDB_ColumnNames('bar.table_name');
CDB_ColumnNames uses schema and table name from regclass
4b5c5dd
Fixes #122
rochoa
Successfully merging a pull request may close this issue.
CDB_ColumnNames current implementation returns columns for any table matching the name.
When having multiple tables with same name but in a different schema it will report the column name from all the tables.
regclass
should be considered when providing qualified table names.The text was updated successfully, but these errors were encountered: