Postgres support, enable information_schema related functionality #181
Description
It would be great if roapi enabled information_schema queries and related commands through the postgres interface. columnq supports this, but currently the errors below occur when attempting to access the database table metadata in roapi
C:\Users\cwhelan>psql -h 127.0.0.1
psql (14.4, server 13)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
cwhelan=> show tables;
ERROR: Error during planning: SHOW TABLES is not supported unless information_schema is enabled
cwhelan=> select * from information_schema;
ERROR: Error during planning: 'datafusion.public.information_schema' not found
cwhelan=> show columns transhist;
ERROR: sql parser error: Expected one of FROM or IN, found: transhist
cwhelan=> show columns from transhist;
ERROR: Error during planning: SHOW COLUMNS is not supported unless information_schema is enabled