You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello there.
After having used sqlite2duckdb, i have tried to get my constraints from the database through the command
query_pkey = """
SELECT kcu.table_name, kcu.column_name
FROM information_schema.table_constraints AS tc
JOIN information_schema.key_column_usage AS kcu
ON tc.constraint_name = kcu.constraint_name
WHERE tc.constraint_type = 'PRIMARY KEY'"""
primary_keys = con.execute(query_pkey).fetchall()
But unfortunatly the constraints from the sqlite database haven't been transferred to the duckdb database.
The text was updated successfully, but these errors were encountered:
Victordeleusse
changed the title
information_schema.table_constraints and key_column_usage always list "memory" for table_catalog on attached databases - CONSTRAINTS are not then well export
CONSTRAINTS not export from sqlite to duckdb
Sep 5, 2024
Hello there.
After having used sqlite2duckdb, i have tried to get my constraints from the database through the command
But unfortunatly the constraints from the sqlite database haven't been transferred to the duckdb database.
The text was updated successfully, but these errors were encountered: