pg_duckdb icon indicating copy to clipboard operation
pg_duckdb copied to clipboard

MotherDuck support

Open JelteF opened this issue 1 year ago • 0 comments

  • Single PG role connected to a single MD user (user may have multiple concurrent PG connections)

  • Table support: user’s MD catalog is synchronized with PG (every x second)

    • MD tables created in MD should be reflected in PG (using CREATE TABLE or CREATE TABLE … AS)
    • MD tables created in PG should be reflected in MD
    • MD tables modified in MD should be reflected in PG
    • Support multiple MD databases by encoding db+schema inside the schemaname ddb$db$schema pattern
  • Users need to choose a designated PG Database for MD synchronization

  • DDL fails in MD/DuckDB, then it should be rolled back in PG

JelteF avatar Sep 30 '24 11:09 JelteF