Hello,

Still working on this GeoNames database.

After reading this guide in the PostgreSQL documentation 
(https://www.postgresql.org/docs/current/populate.html) i see some room of 
improvement in my GeoNames dataset injestion process.

I should drop indexes and foreign key prior to data injection (using COPY 
through DB.copy_into(), thank you Sequel)

May Sequel help a bit to achieve this process quickly by using Db.tables(), 
DB.indexes() and DB.foreign_key_list() ?

Could the result of these methods be used to drop and then recreate indexes 
and foreign_keys ?

Thank you very much,

-- 
Pierre Yager
Crisalid



-- 
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/2952d11a-6c47-40ed-9816-381df5679f1dn%40googlegroups.com.

Reply via email to