Bit types of length > 1 not being detected

[jmriego]

Describe the bug
Bit types of length > 1 not being detected

To Reproduce
create a table with a BIT(8) field:

create table jmtest (
id INTEGER,
name VARCHAR,
somebytes bit(8),
etl_updated_timestamp TIMESTAMP);

Run tap in discover mode:
tap-postgres --config ~/.pipelinewise/bigquery/tap_jmtest/config.json --discover

Expected behavior
We should see the type of the somebytes column. Instead we are getting empty type for this column

Screenshots

Your environment

• Version of tap: 1.8.0
• Version of python 3.7.7

Additional context
This is related to the issue in the main repo: transferwise/pipelinewise#740
It seems to affect all targets and also in a different way this PostgreSQL tap

[Samira-El]

Hey @jmriego,

Bit columns of length > 1 are not currently supported and thus ignored during discovery and sync, see

pipelinewise-tap-postgres/tap_postgres/discovery_utils.py

Line 188 in ae9b211

def schema_for_column_datatype(col):

It would be cool to add support for it tho, and we're open to reviewing a PR if you can work on it.