search

moj-analytical-services / pydbtools

Python version of dbtools
https://moj-analytical-services.github.io/pydbtools/
11 stars 2 forks source link

SHOW TABLES command doesn't work with new read_sql_query #45

Closed andrewc-moj closed 3 years ago

andrewc-moj commented 3 years ago

The previous function pydbtools.read_sql would return information as a dataframe when issued with "SHOW TABLES IN". The new function read_sql_query returns a strange character.

read_sql image

read_sql_query image

andrewc-moj commented 3 years ago

I can use "SELECT * FROM information_schema.columns WHERE table_schema = 'delius_preprod'" so happy to close this issue