Mac OSX sed - removing a string containing a dot from multiple files

Question

Trying to remove a string across multiple files in a directory with sed. The folder contains a large amount of sql files, all with table names that I need to remove. For instance, one of the files looks like this:

INSERT INTO staging.eav_attribute_set (attribute_set_id, entity_type_id, attribute_set_name, sort_order) VALUES (1, 1, 'Default', 2);
INSERT INTO staging.eav_attribute_set (attribute_set_id, entity_type_id, attribute_set_name, sort_order) VALUES (2, 2, 'Default', 2);
INSERT INTO staging.eav_attribute_set (attribute_set_id, entity_type_id, attribute_set_name, sort_order) VALUES (3, 3, 'Default', 1);
INSERT INTO staging.eav_attribute_set (attribute_set_id, entity_type_id, attribute_set_name, sort_order) VALUES (4, 4, 'Default', 1);

I need to remove staging. from all lines. I've tried the following from the directory where the files are:

sed -i 's/staging.//g' *
sed -i 's/staging\.//g' *
sed -i 's|staging.||g' *

But receive the following:

sed: 1: "eav_attribute_set ...": unterminated substitute pattern

Answer 1

With FreeBSD sed (as found on macOS), you need:

sed -i '' 's/staging\.//g' ./*

Answer 2

This going to remove staging. in your file.

cat ${yourfile} | sed 's/staging\.//g' > tmp && mv tmp ${yourfile}