Escape tablename for avoiding table naming issue.

[onlinemad]

Hi,

It will occur "column "id" does not exist" if the table named "user" durning diff process. So, it might be escape table name for avoiding table naming issue.

pgdatadiff/pgdatadiff/pgdatadiff.py

Line 64 in caf9b45

FROM {tablename}

Thank you.

[akamai-drosser]

I have run into this issue as well, the fix seems simple enough (putting quotes around {tablename}:

...
SQL_TEMPLATE_HASH = f"""
SELECT md5(array_agg(md5((t.*)::varchar))::varchar)
FROM (
SELECT *
FROM "{tablename}"
ORDER BY {pk} limit :row_limit offset :row_offset
) AS t;
"""
...