Hi,
I'm using the copy_table method to extract a 1 billion row Postgres table
to csv in parts. This could be made simpler if copy_table returned an
Enumerator instead of the entire table contents (if no block is given), as
I could use the each_slice method.
DB.copy_table(:table).each_slice(10000).with_index(1) do |part, part_count|
File.open(format('%s_%05d.csv', :table, part_count), 'w') do |csv_part|
part.each do |row|
csv_part.puts(row)
end
end
end
Here is a possible implementation
<https://github.com/LS80/sequel/commit/580bde8f54af0c98e7c5163c392fce027c663c30>
.
Any thoughts on a change like this?
Regards,
Lee
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
