duckdb / duckdb/duckdb-postgres
Error copying postgres DB to duckdb using build 0.9.3.dev2938 when using the new ATTACH functionality
- Dominant language
- C++
- Stars
- 372
- Forks
- 105
- Avg merge
- 10h 19m
- Merged PRs (30d)
- 18
Description
### What happens?
According to the documentation database copying should be available when using dev version of DuckDB but I get the following error when trying to copy a postgres database to a duckdb database. I know its a dev release but thought you guys might be interested
CatalogException: Catalog Error: Schema with name pg_toast does not exist!
### To Reproduce
Installed Postgres v16 on my local system and created a database with one table. Next ran the following code fragment after pip installing 0.9.3.dev2938 of duckdb
import duckdb as db
db.sql("ATTACH 'dbname=postgres user=my_db_user password=my_db_pass host=127.0.0.1' AS db_postgres (TYPE postgres)")
# attach a DuckDB file
db.sql("ATTACH 'database.db' AS ddb")
# export all tables and views from the Postgres database to the DuckDB file
db.sql("COPY FROM DATABASE db_postgres TO ddb")
### OS:
Windows 11
### DuckDB Version:
0.9.3.dev2938
### DuckDB Client:
3.11
### Full Name:
Tom Reid
### Affiliation:
None
### Have you tried this on the latest [nightly build](https://duckdb.org/docs/installation/?version=main)?
I have tested with a nightly build
### Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- [X] Yes, I have
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.