I am using the tool pgloader to copy all tables and table schema from an SQLite database to our postgres instance. The tool works great and does a great job automatically mapping the table schema and copying the tables, but the data outputs to the “public” schema within postgres. I cannot figure out for the life of me how to have pgloader export to a different schema. Has anyone figured this out?
I tried using the “ALTER SCHEMA” command but it still output to the public schema.