Extra columns name and key column with different names for the second table to compare data from.

[Ryuk-me]

My source and target tables have different column names, including the key column. How can I achieve this if it's supported using python api.

My current workaround is to create a temporary view for the comparison.

[Ryuk-me]

from reladiff import connect_to_table, diff_tables

table1 = connect_to_table(
    "postgresql://postgres:password@localhost:5432/dvdrental",
    "actor",
    "actor_id",
    extra_columns=(
        "first_name",
        "last_name",
        "last_update",
    ),
)
table2 = connect_to_table(
    "postgresql://postgres:password@localhost:5432/dvdrental2",
    "actor2",
    "actor_id1",
    extra_columns=(
        "first_name1",
        "last_name1",
        "last_update1",
    ),
)

for sign, row in diff_tables(table1, table2):
    print(sign, row)

[erezsh]

Looks correct :)