-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/04/2014 11:59 AM, Petite Abeille wrote: >> On Dec 4, 2014, at 8:44 AM, Baruch Burstein >> <bmburst...@gmail.com> wrote: >> >> Is it possible to somehow search for/replace a string in all >> columns of all tables? > > .dump | sed ’s/old/new/g' | .read ?
That will only work under the simplest of cases. For example if "old" occurs anywhere outside a value (eg table name, text of a trigger, index, column) then the database won't be right. Baruch also didn't say if "old" should be an entire value match or a substring match - the former won't work with sed reliably. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlSA0Y4ACgkQmOOfHg372QTCDgCfbsJR9uJ/tVlYVnnn0clU1Egr x/YAoOUuleJXlh3XEADeAm9CO/DH47qZ =/ItF -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
