On Friday, August 14, 2020 at 11:50:44 AM UTC-7, Anant M wrote: > > Thanks! Will look more into this. > > Having some trouble with the general sequel -C dbfrom dbto. > > We had some empty strings in the sqlite database and made our changes to > them. The import was working fine for the database where I manually input > null/values, and in this database we used "update" if empty string, I am > getting the following error: > > Error: Sequel::DatabaseError: PG::UndefinedTable: ERROR: relation > "courses" does not exist > > One thought is that the table names get wrapped with double quotes when > moving into psql, but that is strange because the other database imports > just fine, and there are no other changes. > > Is there a way to change this or to see what's going on? >
You can run with the -E flag which will log all SQL queries emitted. Also, note that the copy (-C) option is fairly limited, as explained at http://sequel.jeremyevans.net/rdoc/files/doc/bin_sequel_rdoc.html#label-Copy+Databases Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/9dcb91c0-0b78-4f4d-a41c-38d1735d2430o%40googlegroups.com.
