Skip to content

CONSTRAINTS not export from sqlite to duckdb #1

@Victordeleusse

Description

@Victordeleusse

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions