duckdb / duckdb/duckdb-postgres

Error copying postgres DB to duckdb using build 0.9.3.dev2938 when using the new ATTACH functionality

Open
#178 1 comment 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.