DROP SERVER IF EXISTS lims_db CASCADE;
CREATE SERVER lims_db
FOREIGN DATA WRAPPER odbc_fdw
OPTIONS (
odbc_DRIVER 'MySQL ODBC 8.0 Unicode Driver',
odbc_SERVER '192.168.5.247'
);


CREATE USER MAPPING FOR postgres
SERVER lims_db
OPTIONS (odbc_UID 'cato', odbc_PWD 'Cato2020');

CREATE FOREIGN TABLE
  lims_report (
    id INTEGER,
    report_no text
  )
  SERVER lims_db
  OPTIONS (
    odbc_DATABASE 'cato',
    sql_query 'select id, report_no from `bv_report_index`',
    sql_count 'select count(id) from `bv_report_index`'
  );