postgresql-to-sqlite icon indicating copy to clipboard operation
postgresql-to-sqlite copied to clipboard

convert schema to table prefix automatically

Open tcecyk opened this issue 6 months ago • 1 comments

What do you think about doing an automatic schema to table prefix conversion and logging an info notice to stdout? You allude to a schema rename / removal being necessary in your stackoverflow answer.

Even if only done for "public" automatically, the very common case, it would help most naive users, as the error message doesn't suggest it.

[SQLITE_ERROR] SQL error or missing database (no such table: public.example)

An alternative is outputting a warning within the Copy command if a schema is found. Would you accept a PR on this?

tcecyk avatar Oct 20 '25 15:10 tcecyk

This is good idea, unfortunately have no time to do it. PR is welcomed.

caiiiycuk avatar Oct 21 '25 06:10 caiiiycuk