Open ibotty opened 5 months ago
It would be great to allow the UUID type. ATM you'll get an error, that it's not supported.
A workaround is to create the column in duckdb's table with type UUID and the PostgreSQL foreign table's type with type TEXT.
UUID
TEXT
Maybe this will be useful https://github.com/pgspider/sqlite_fdw/commit/d6387a8ea33129d69c45389ee20180d809a03f03 https://github.com/pgspider/sqlite_fdw/commit/a272452097d6997ac7f44baa70b5b627450f3ded
It would be great to allow the UUID type. ATM you'll get an error, that it's not supported.
A workaround is to create the column in duckdb's table with type
UUID
and the PostgreSQL foreign table's type with typeTEXT
.