postgres_scanner

postgres_scanner copied to clipboard

If I have a postgres server attached at my_pg_db, I want to be able to do CREATE TEMP TABLE my_pg_db.public.tmp_table AS SELECT my_col from my_pg_db.public.original, and have this create a temp table on the postgres side. Currently this results in ParserException: Parser Error: TEMPORARY table names can *only* use the "temp" catalog. IDK, if this actually is a parser exception, then this might be out of control of this extension, and duckdb itself would have to change it's parser. If you have a suggestion for a workaround in the meantime to create temp tables on the postgres side, that would be awesome. Thanks!