Dirty SQL Data Migration Technique

dump_wineries.sql

--
-- how to populate locations table on db2 from wineries table on db1
--


-- SELECT  "INSERT INTO locations( name, website, address, address2, city, state, zip, country, phone, created_at, updated_at, latitude, longitude, email, fax, winery_id ) VALUES (" || name ||", " || website || ", " || address || ", null , null, null, null, null, " || phone || ", " || created_at || ", " || modified_at || ",null, null, " || email || ", " || fax || ", " || winery_id  || "); " FROM wineries


SELECT  'INSERT INTO locations( name, winery_id ) VALUES ("' || name || '", "' || winery_id || '"); ' FROM wineries


--
-- pgsql [dbname] < dump_wineries.sql > output.sql
--