Generate types for foreign tables

[bastiaanv]

Bug report

Describe the bug

When running Supabase gen typescript --db-url <URL> > database.ts the tables that are connected via FDW to ClickHouse are not generating types

To Reproduce

1. Setup FDW and create a ClickHouse handler. Then create a foreign table like this:

create foreign table glucose (
  timestamp timestamp,
  profile_id text,
  sensor_id text,
  glucose_mmol real,
  glucose_mg integer
)
  server clickhouse_server
  options (
    table 'glucose',
    rowid_column 'timestamp'
  );

2. First create docker image:

docker run -e PG_META_DB_URL=<URL> -it supabase/postgres-meta:v0.65.0 bash

3. Run generate types command:

node dist/server/app.js gen types typescript --include-schemas public > database.ts

4. Notice the foreign tables are not listed in the database.ts

Expected behavior

To have all foreign tables to be listed

System information

• OS: MacOS
• Version of Supabase-cli: 1.38.7
• Version of pgmeta: v0.65.0
• Version of Node.js: v19.6.1

[thisisamir98]

@bastiaanv I'm also facing the same issue with my project but with stripe wrapper integration, have you found any workarounds on this?

[bastiaanv]

No I did not. Made the types myself

[codingisforlosers]

Upvoting!

[zgiuricich7]

Also running into this issue for the stripe wrapper integration.