Re: Find and replace

"Campbell, Lance" <[email protected]> Wed, 11 Sep 2019 20:31:09 +0000
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]>
--_000_9785FB9BA4F04820812F91A233DA0A9Aillinoisedu_
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

SSBkb27igJl0IHRoaW5rIHRoYXQgaXMgYW4gb3B0aW9uLiAgVGhlIHRleHQgSSBhbSBkb2luZyB0
aGUgZmluZCBhbmQgcmVwbGFjZSBvbiBjb250YWlucyBDU1MuICBJIGJlbGlldmUgdGhlcmUgd2ls
bCBiZSBzcXVpZ2dseSBicmFja2V0cyBpbiB0aGUgQ1NTLiAgSG93ZXZlciwgaXQgc2hvdWxkIGhh
dmUgc3BhY2VzIG9yIGNhcnJpYWdlIHJldHVybiBsaW5lIGZlZWRzIGJldHdlZW4gdGhlIGJyYWNr
ZXRzIHNvIHRoZXJlIHdpbGwgbm90IGJlIGFueSBpc3N1ZXMuDQoNCkZyb206IFJvYiBTYXJnZW50
IDxyb2Jqc2FyZ2VudEBnbWFpbC5jb20+DQpEYXRlOiBXZWRuZXNkYXksIFNlcHRlbWJlciAxMSwg
MjAxOSBhdCAzOjI3IFBNDQpUbzogTGFuY2UgQ2FtcGJlbGwgPGxhbmNlQGlsbGlub2lzLmVkdT4N
CkNjOiAicGdzcWwtc3FsQHBvc3RncmVzcWwub3JnIiA8cGdzcWwtc3FsQHBvc3RncmVzcWwub3Jn
Pg0KU3ViamVjdDogUmU6IEZpbmQgYW5kIHJlcGxhY2UNCg0KDQoNCg0KT24gU2VwIDExLCAyMDE5
LCBhdCAyOjI0IFBNLCBDYW1wYmVsbCwgTGFuY2UgPGxhbmNlQGlsbGlub2lzLmVkdTxtYWlsdG86
bGFuY2VAaWxsaW5vaXMuZWR1Pj4gd3JvdGU6DQoNClBvc3RncmVTUUwgMTAueA0KDQpJIGRvbuKA
mXQga25vdyB0aGUgYmVzdCB3YXkgdG8gZG8gdGhpcy4gIEkgbmVlZCB0byBkbyBhIGZpbmQgYW5k
IHJlcGxhY2UgaW4gdGV4dCBmaWVsZHMuICBUaGUgdmFsdWUgSSBuZWVkIHRvIGZpbmQgYW5kIHJl
cGxhY2UgbWF5IG9jY3VyIG1vcmUgdGhhbiBvbmNlIGluIGVhY2ggZmllbGQgcGVyIHJlY29yZC4N
Cg0KVGhlIHZhbHVlIEkgYW0gdHJ5aW5nIHRvIG1hdGNoIG9uOg0KU3RhcnRzIHdpdGggYSBzaW5n
bGUgeyAuDQpFbmRzIHdpdGggYSBzaW5nbGUgfSAuDQpJbiBiZXR3ZWVuIHRoZXNlIGJyYWNrZXRz
IGNhbiBiZSB0aGUgY2hhcmFjdGVycyAwLTksIGEteiwgQS1aLCBoeXBoZW5zIGFuZCB1bmRlcnNj
b3Jlcy4gIEJ1dCBubyBzcGFjZXMuICBUaGVzZSBjaGFyYWN0ZXJzIGNvdWxkIGJlIGluIGFueSBv
cmRlci4NClRoZSByZXBsYWNlbWVudCB2YWx1ZSBvbiBhIG1hdGNoIGlzIHRoZSBzYW1lIGFzIHdo
YXQgd2FzIGZvdW5kIGV4Y2VwdCBmb3IgZG91YmxlIHt7IGF0IHRoZSBiZWdpbm5pbmcgYW5kIGRv
dWJsZSB9fSBhdCB0aGUgZW5kLiAgU2FtZSB2YWx1ZXMgYmV0d2VlbiB0aGUgYnJhY2tldHMgYXMg
d2hhdCB3YXMgbWF0Y2hlZCBvbi4NCg0KRXhhbXBsZToNCnthYl8xRDMtNH0gYmVjb21lcyB7e2Fi
XzFEMy00fX0NCg0KVGhhbmtzIGZvciBoZWxwaW5nIG1lIHdpdGggdGhpcy4NCg0KTGFuY2UgQ2Ft
cGJlbGwNClVuaXZlcnNpdHkgb2YgSWxsaW5vaXMNCg0KQXJlIHRoZXJlIGN1cmx5IGJyYWNlcyB3
aGljaCBkb27igJl0IHN0YXJ0L2VuZCBzdWNoIHN0cmluZ3M/ICBJZiBub3QgaXQgbWlnaHQgYmUg
ZWFzaWVyIHRvIGp1c3QgZG91YmxlIHRoZW0gdXA/DQoNCg0KDQo=

--_000_9785FB9BA4F04820812F91A233DA0A9Aillinoisedu_
Content-Type: text/html; charset="utf-8"
Content-ID: <[email protected]>
Content-Transfer-Encoding: base64

PGh0bWwgeG1sbnM6bz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6b2ZmaWNlIiB4
bWxuczp3PSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTp3b3JkIiB4bWxuczptPSJo
dHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL29mZmljZS8yMDA0LzEyL29tbWwiIHhtbG5zPSJo
dHRwOi8vd3d3LnczLm9yZy9UUi9SRUMtaHRtbDQwIj4NCjxoZWFkPg0KPG1ldGEgaHR0cC1lcXVp
dj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPG1l
dGEgbmFtZT0iR2VuZXJhdG9yIiBjb250ZW50PSJNaWNyb3NvZnQgV29yZCAxNSAoZmlsdGVyZWQg
bWVkaXVtKSI+DQo8c3R5bGU+PCEtLQ0KLyogRm9udCBEZWZpbml0aW9ucyAqLw0KQGZvbnQtZmFj
ZQ0KCXtmb250LWZhbWlseToiQ2FtYnJpYSBNYXRoIjsNCglwYW5vc2UtMToyIDQgNSAzIDUgNCA2
IDMgMiA0O30NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6Q2FsaWJyaTsNCglwYW5vc2UtMToy
IDE1IDUgMiAyIDIgNCAzIDIgNDt9DQovKiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3Jt
YWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0KCXttYXJnaW46MGluOw0KCW1hcmdpbi1i
b3R0b206LjAwMDFwdDsNCglmb250LXNpemU6MTEuMHB0Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp
IixzYW5zLXNlcmlmO30NCmE6bGluaywgc3Bhbi5Nc29IeXBlcmxpbmsNCgl7bXNvLXN0eWxlLXBy
aW9yaXR5Ojk5Ow0KCWNvbG9yOmJsdWU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQph
OnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQNCgl7bXNvLXN0eWxlLXByaW9yaXR5
Ojk5Ow0KCWNvbG9yOnB1cnBsZTsNCgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30NCnAubXNv
bm9ybWFsMCwgbGkubXNvbm9ybWFsMCwgZGl2Lm1zb25vcm1hbDANCgl7bXNvLXN0eWxlLW5hbWU6
bXNvbm9ybWFsOw0KCW1zby1tYXJnaW4tdG9wLWFsdDphdXRvOw0KCW1hcmdpbi1yaWdodDowaW47
DQoJbXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG87DQoJbWFyZ2luLWxlZnQ6MGluOw0KCWZvbnQt
c2l6ZToxMS4wcHQ7DQoJZm9udC1mYW1pbHk6IkNhbGlicmkiLHNhbnMtc2VyaWY7fQ0Kc3Bhbi5F
bWFpbFN0eWxlMTgNCgl7bXNvLXN0eWxlLXR5cGU6cGVyc29uYWwtcmVwbHk7DQoJZm9udC1mYW1p
bHk6IkNhbGlicmkiLHNhbnMtc2VyaWY7DQoJY29sb3I6d2luZG93dGV4dDt9DQouTXNvQ2hwRGVm
YXVsdA0KCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25seTsNCglmb250LXNpemU6MTAuMHB0O30N
CkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXplOjguNWluIDExLjBpbjsNCgltYXJnaW46MS4waW4g
MS4waW4gMS4waW4gMS4waW47fQ0KZGl2LldvcmRTZWN0aW9uMQ0KCXtwYWdlOldvcmRTZWN0aW9u
MTt9DQotLT48L3N0eWxlPg0KPC9oZWFkPg0KPGJvZHkgbGFuZz0iRU4tVVMiIGxpbms9ImJsdWUi
IHZsaW5rPSJwdXJwbGUiPg0KPGRpdiBjbGFzcz0iV29yZFNlY3Rpb24xIj4NCjxwIGNsYXNzPSJN
c29Ob3JtYWwiPkkgZG9u4oCZdCB0aGluayB0aGF0IGlzIGFuIG9wdGlvbi4mbmJzcDsgVGhlIHRl
eHQgSSBhbSBkb2luZyB0aGUgZmluZCBhbmQgcmVwbGFjZSBvbiBjb250YWlucyBDU1MuJm5ic3A7
IEkgYmVsaWV2ZSB0aGVyZSB3aWxsIGJlIHNxdWlnZ2x5IGJyYWNrZXRzIGluIHRoZSBDU1MuJm5i
c3A7IEhvd2V2ZXIsIGl0IHNob3VsZCBoYXZlIHNwYWNlcyBvciBjYXJyaWFnZSByZXR1cm4gbGlu
ZSBmZWVkcyBiZXR3ZWVuIHRoZSBicmFja2V0cyBzbyB0aGVyZQ0KIHdpbGwgbm90IGJlIGFueSBp
c3N1ZXMuPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwv
bzpwPjwvcD4NCjxkaXYgc3R5bGU9ImJvcmRlcjpub25lO2JvcmRlci10b3A6c29saWQgI0I1QzRE
RiAxLjBwdDtwYWRkaW5nOjMuMHB0IDBpbiAwaW4gMGluIj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwi
PjxiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTIuMHB0O2NvbG9yOmJsYWNrIj5Gcm9tOiA8L3Nw
YW4+PC9iPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTIuMHB0O2NvbG9yOmJsYWNrIj5Sb2IgU2Fy
Z2VudCAmbHQ7cm9ianNhcmdlbnRAZ21haWwuY29tJmd0Ozxicj4NCjxiPkRhdGU6IDwvYj5XZWRu
ZXNkYXksIFNlcHRlbWJlciAxMSwgMjAxOSBhdCAzOjI3IFBNPGJyPg0KPGI+VG86IDwvYj5MYW5j
ZSBDYW1wYmVsbCAmbHQ7bGFuY2VAaWxsaW5vaXMuZWR1Jmd0Ozxicj4NCjxiPkNjOiA8L2I+JnF1
b3Q7cGdzcWwtc3FsQHBvc3RncmVzcWwub3JnJnF1b3Q7ICZsdDtwZ3NxbC1zcWxAcG9zdGdyZXNx
bC5vcmcmZ3Q7PGJyPg0KPGI+U3ViamVjdDogPC9iPlJlOiBGaW5kIGFuZCByZXBsYWNlPG86cD48
L286cD48L3NwYW4+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86
cD4mbmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5i
c3A7PC9vOnA+PC9wPg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxicj4NCjxicj4NCjxv
OnA+PC9vOnA+PC9wPg0KPGJsb2NrcXVvdGUgc3R5bGU9Im1hcmdpbi10b3A6NS4wcHQ7bWFyZ2lu
LWJvdHRvbTo1LjBwdCI+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+T24gU2VwIDExLCAy
MDE5LCBhdCAyOjI0IFBNLCBDYW1wYmVsbCwgTGFuY2UgJmx0OzxhIGhyZWY9Im1haWx0bzpsYW5j
ZUBpbGxpbm9pcy5lZHUiPmxhbmNlQGlsbGlub2lzLmVkdTwvYT4mZ3Q7IHdyb3RlOjxvOnA+PC9v
OnA+PC9wPg0KPC9kaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwv
cD4NCjxkaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+UG9zdGdyZVNRTCAxMC54PHNw
YW4gc3R5bGU9ImZvbnQtc2l6ZToxMi4wcHQiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjwvZGl2
Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPiZuYnNwOzxzcGFuIHN0eWxlPSJmb250LXNp
emU6MTIuMHB0Ij48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFz
cz0iTXNvTm9ybWFsIj5JIGRvbuKAmXQga25vdyB0aGUgYmVzdCB3YXkgdG8gZG8gdGhpcy4mbmJz
cDsgSSBuZWVkIHRvIGRvIGEgZmluZCBhbmQgcmVwbGFjZSBpbiB0ZXh0IGZpZWxkcy4mbmJzcDsg
VGhlIHZhbHVlIEkgbmVlZCB0byBmaW5kIGFuZCByZXBsYWNlIG1heSBvY2N1ciBtb3JlIHRoYW4g
b25jZSBpbiBlYWNoIGZpZWxkIHBlciByZWNvcmQuJm5ic3A7PHNwYW4gc3R5bGU9ImZvbnQtc2l6
ZToxMi4wcHQiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNz
PSJNc29Ob3JtYWwiPiZuYnNwOzxzcGFuIHN0eWxlPSJmb250LXNpemU6MTIuMHB0Ij48bzpwPjwv
bzpwPjwvc3Bhbj48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5UaGUg
dmFsdWUgSSBhbSB0cnlpbmcgdG8gbWF0Y2ggb246PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMi4w
cHQiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29O
b3JtYWwiPlN0YXJ0cyB3aXRoIGEgc2luZ2xlIHsgLjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTIu
MHB0Ij48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNv
Tm9ybWFsIj5FbmRzIHdpdGggYSBzaW5nbGUgfSAuPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMi4w
cHQiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29O
b3JtYWwiPkluIGJldHdlZW4gdGhlc2UgYnJhY2tldHMgY2FuIGJlIHRoZSBjaGFyYWN0ZXJzIDAt
OSwgYS16LCBBLVosIGh5cGhlbnMgYW5kIHVuZGVyc2NvcmVzLiZuYnNwOyBCdXQgbm8gc3BhY2Vz
LiZuYnNwOyBUaGVzZSBjaGFyYWN0ZXJzIGNvdWxkIGJlIGluIGFueSBvcmRlci48c3BhbiBzdHls
ZT0iZm9udC1zaXplOjEyLjBwdCI+PG86cD48L286cD48L3NwYW4+PC9wPg0KPC9kaXY+DQo8ZGl2
Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+VGhlIHJlcGxhY2VtZW50IHZhbHVlIG9uIGEgbWF0Y2gg
aXMgdGhlIHNhbWUgYXMgd2hhdCB3YXMgZm91bmQgZXhjZXB0IGZvciBkb3VibGUge3sgYXQgdGhl
IGJlZ2lubmluZyBhbmQgZG91YmxlIH19IGF0IHRoZSBlbmQuJm5ic3A7IFNhbWUgdmFsdWVzIGJl
dHdlZW4gdGhlIGJyYWNrZXRzIGFzIHdoYXQgd2FzIG1hdGNoZWQgb24uPHNwYW4gc3R5bGU9ImZv
bnQtc2l6ZToxMi4wcHQiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxw
IGNsYXNzPSJNc29Ob3JtYWwiPiZuYnNwOzxzcGFuIHN0eWxlPSJmb250LXNpemU6MTIuMHB0Ij48
bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFs
Ij5FeGFtcGxlOjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTIuMHB0Ij48bzpwPjwvbzpwPjwvc3Bh
bj48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj57YWJfMUQzLTR9IGJl
Y29tZXMge3thYl8xRDMtNH19PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMi4wcHQiPjxvOnA+PC9v
OnA+PC9zcGFuPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPiZuYnNw
OzxzcGFuIHN0eWxlPSJmb250LXNpemU6MTIuMHB0Ij48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8
L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5UaGFua3MgZm9yIGhlbHBpbmcgbWUg
d2l0aCB0aGlzLjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTIuMHB0Ij48bzpwPjwvbzpwPjwvc3Bh
bj48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj4mbmJzcDs8c3BhbiBz
dHlsZT0iZm9udC1zaXplOjEyLjBwdCI+PG86cD48L286cD48L3NwYW4+PC9wPg0KPC9kaXY+DQo8
ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+TGFuY2UgQ2FtcGJlbGw8c3BhbiBzdHlsZT0iZm9u
dC1zaXplOjEyLjBwdCI+PG86cD48L286cD48L3NwYW4+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAg
Y2xhc3M9Ik1zb05vcm1hbCI+VW5pdmVyc2l0eSBvZiBJbGxpbm9pczxzcGFuIHN0eWxlPSJmb250
LXNpemU6MTIuMHB0Ij48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9i
bG9ja3F1b3RlPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8
L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5BcmUgdGhlcmUgY3VybHkgYnJhY2Vz
IHdoaWNoIGRvbuKAmXQgc3RhcnQvZW5kIHN1Y2ggc3RyaW5ncz8gJm5ic3A7SWYgbm90IGl0IG1p
Z2h0IGJlIGVhc2llciB0byBqdXN0IGRvdWJsZSB0aGVtIHVwPzxvOnA+PC9vOnA+PC9wPg0KPC9k
aXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8
L2Rpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxicj4NCjxicj4NCjxvOnA+PC9vOnA+PC9wPg0K
PC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo=

--_000_9785FB9BA4F04820812F91A233DA0A9Aillinoisedu_--