Published inFrancium TechDelete duplicate records in PostgreSQL table without any unique column.You want to delete the duplicates of the table which don’t have any unique column like ID. Then this ctid useful to delete duplicate even…Jul 10, 2019Jul 10, 2019
Published inFrancium TechPostgres copy data using dblink extension.https://www.postgresql.org/docs/9.3/contrib-dblink-function.htmlJan 7, 2019Jan 7, 2019
Published inFrancium TechNotes: Rails console historySometimes you would want to see what are the scripts that you ran in the IRB or rails console. For debugging reasons of course.Nov 2, 2018Nov 2, 2018
Published inFrancium TechThe lifecycle of rubies regular expression global variable $1, $2, …I was trying to replace the string “$200 billion” with the decimal “$200.0 billion”. I used the gsub string replace function in ruby which…Oct 10, 2018Oct 10, 2018
Published inFrancium TechPostgres’s NumericValueOutOfRangeWhen you run into an error something like this,May 11, 2018May 11, 2018
Published inFrancium TechRuby gsub for capture and reinsert sub-matches on the stringIn ruby, sub and gsub are very useful and powerful string operators.Apr 24, 2018Apr 24, 2018
Published inFrancium TechNotes: Read CSV with encoding ISO-8859–1 in RubyI was struggling to read a CSV file and load it in PostgreSQL using ruby. Simply, the following code block should work.Mar 13, 2018Mar 13, 2018
Published inFrancium TechCreating partitions for large tables in PostgreSQLCreate partition table with different name, something related to the source table.Dec 20, 2017Dec 20, 2017
