def sequence_values(rep_prefix, table_name)
result = {}
sequence_names = select_all("select s.relname\nfrom pg_class as t\njoin pg_depend as r on t.oid = r.refobjid\njoin pg_class as s on r.objid = s.oid\nand s.relkind = 'S'\nand t.relname = '\#{table_name}' AND t.relnamespace IN\n(SELECT oid FROM pg_namespace WHERE nspname in (\#{schemas}))\n").map { |row| row['relname'] }
sequence_names.each do |sequence_name|
row = select_one("select last_value, increment_by from \"#{sequence_name}\"")
result[sequence_name] = {
:increment => row['increment_by'].to_i,
:value => row['last_value'].to_i
}
end
result
end