pgAdmin 4 commit: Added Schema Diff tool to compare two schemas and gen

Akshay Joshi <[email protected]> Fri, 10 Jan 2020 10:12:45 +0000
Newsgroups gmane.comp.db.postgresql.pgadmin.devel
Message-ID <[email protected]>
--===============4246082258930727498==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64

QWRkZWQgU2NoZW1hIERpZmYgdG9vbCB0byBjb21wYXJlwqB0d28gc2NoZW1hcyBhbmQgZ2VuZXJh
dGUgdGhlIGRpZmZlcmVuY2Ugc2NyaXB0LgoKQ3VycmVudGx5wqBzdXBwb3J0ZWQgb2JqZWN0cyBh
cmUgVGFibGUsIFZpZXcsIE1hdGVyaWFsaXplZCBWaWV3LCBGdW5jdGlvbiBhbmQgUHJvY2VkdXJl
LgoKQmFja2VuZCBjb21wYXJpc29uIG9mIHR3byBzY2hlbWFzIGltcGxlbWVudGVkIGJ5OiBBa3No
YXkgSm9zaGkKCkZpeGVzICMzNDUyLgoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0t
LS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9naXR3ZWI/cD1wZ2FkbWluNC5naXQ7YT1j
b21taXRkaWZmO2g9NDVmMmUzNWE5OWVlNjkxZDY3YzQ1OTgyMjExMjM4YjhhZDQwZDdkZQpBdXRo
b3I6IEtodXNoYm9vIFZhc2hpIDxraHVzaGJvby52YXNoaUBlbnRlcnByaXNlZGIuY29tPgoKTW9k
aWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jcy9lbl9VUy9yZWxlYXNlX25vdGVzXzRfMTgu
cnN0ICAgICAgICAgICAgICAgICAgfCAgIDEgKwouLi4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3Nl
cnZlcnMvX19pbml0X18ucHkgICAgICB8ICAgMiArCi4uLi9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv
ZGF0YWJhc2VzL19faW5pdF9fLnB5ICAgIHwgICAzICsKLi4uL3NlcnZlcnMvZGF0YWJhc2VzL3Nj
aGVtYXMvX19pbml0X18ucHkgICAgICAgICAgfCAgIDIgKwouLi4vZGF0YWJhc2VzL3NjaGVtYXMv
Y29sbGF0aW9ucy9fX2luaXRfXy5weSAgICAgICB8ICA2NSArLQouLi4vc2VydmVycy9kYXRhYmFz
ZXMvc2NoZW1hcy9kb21haW5zL19faW5pdF9fLnB5ICB8ICA3OSArLQouLi4vZG9tYWlucy9zcWwv
OS4yX3BsdXMvZ2V0X2NvbnN0cmFpbnRzLnNxbCAgICAgICB8ICAgMiArLQouLi4vZG9tYWlucy9z
cWwvZGVmYXVsdC9nZXRfY29uc3RyYWludHMuc3FsICAgICAgICB8ICAgMiArLQouLi4vZGF0YWJh
c2VzL3NjaGVtYXMvZm9yZWlnbl90YWJsZXMvX19pbml0X18ucHkgICB8IDExNiArLS0KLi4uL3Nj
aGVtYXMvZnRzX2NvbmZpZ3VyYXRpb25zL19faW5pdF9fLnB5ICAgICAgICAgfCAgNTkgKy0KLi4u
L2RhdGFiYXNlcy9zY2hlbWFzL2Z0c19kaWN0aW9uYXJpZXMvX19pbml0X18ucHkgfCAgNTkgKy0K
Li4uL2RhdGFiYXNlcy9zY2hlbWFzL2Z0c19wYXJzZXJzL19faW5pdF9fLnB5ICAgICAgfCAgNjkg
Ky0KLi4uL2RhdGFiYXNlcy9zY2hlbWFzL2Z0c190ZW1wbGF0ZXMvX19pbml0X18ucHkgICAgfCAg
NzAgKy0KLi4uL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy9fX2luaXRfXy5weSAgICAgICAg
fCAgOTIgKystCi4uLi9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3BhY2thZ2VzL19faW5pdF9f
LnB5IHwgMTA1ICsrLQouLi4vc2NoZW1hcy9wYWNrYWdlcy9lZGJmdW5jcy9fX2luaXRfXy5weSAg
ICAgICAgICB8ICAgNSArLQouLi4vZGF0YWJhc2VzL3NjaGVtYXMvcGFja2FnZXMvZWRidmFycy9f
X2luaXRfXy5weSB8ICAgNSArLQouLi4vZGF0YWJhc2VzL3NjaGVtYXMvc2VxdWVuY2VzL19faW5p
dF9fLnB5ICAgICAgICB8ICA2MSArLQouLi4vc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9zeW5v
bnltcy9fX2luaXRfXy5weSB8ICA2NCArLQouLi4vc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90
YWJsZXMvX19pbml0X18ucHkgICB8IDE5MiArKysrLQouLi4vZGF0YWJhc2VzL3NjaGVtYXMvdGFi
bGVzL2NvbHVtbnMvX19pbml0X18ucHkgICB8ICAgMSArCi4uLi9zY2hlbWFzL3RhYmxlcy9jb21w
b3VuZF90cmlnZ2Vycy9fX2luaXRfXy5weSAgIHwgMTQyICsrKy0KLi4uL3RhYmxlcy9jb25zdHJh
aW50cy9pbmRleF9jb25zdHJhaW50L3V0aWxzLnB5ICAgfCAgIDQgKy0KLi4uL2RhdGFiYXNlcy9z
Y2hlbWFzL3RhYmxlcy9pbmRleGVzL19faW5pdF9fLnB5ICAgfCAyMDQgKysrKy0KLi4uL2RhdGFi
YXNlcy9zY2hlbWFzL3RhYmxlcy9pbmRleGVzL3V0aWxzLnB5ICAgICAgfCAgMTUgKy0KLi4uL3Nj
aGVtYXMvdGFibGVzL3BhcnRpdGlvbnMvX19pbml0X18ucHkgICAgICAgICAgfCAxODMgKysrKy0K
Li4uL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9ydWxlcy9fX2luaXRfXy5weSAgICAgfCAxMjcg
KysrLQouLi4vZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3NjaGVtYV9kaWZmX3V0aWxzLnB5ICB8
IDUwNyArKysrKysrKysrKysrCi4uLi90ZW1wbGF0ZXMvY29sdW1ucy9zcWwvMTBfcGx1cy9jcmVh
dGUuc3FsICAgICAgIHwgICAyICstCi4uLi90ZW1wbGF0ZXMvY29sdW1ucy9zcWwvMTBfcGx1cy91
cGRhdGUuc3FsICAgICAgIHwgIDEyICstCi4uLi90ZW1wbGF0ZXMvY29sdW1ucy9zcWwvMTJfcGx1
cy9jcmVhdGUuc3FsICAgICAgIHwgICAyICstCi4uLi90ZW1wbGF0ZXMvY29sdW1ucy9zcWwvOS4y
X3BsdXMvdXBkYXRlLnNxbCAgICAgIHwgIDEwICstCi4uLi90ZW1wbGF0ZXMvY29sdW1ucy9zcWwv
ZGVmYXVsdC9jcmVhdGUuc3FsICAgICAgIHwgICAyICstCi4uLi90ZW1wbGF0ZXMvY29sdW1ucy9z
cWwvZGVmYXVsdC91cGRhdGUuc3FsICAgICAgIHwgIDE0ICstCi4uLi90ZW1wbGF0ZXMvcGFydGl0
aW9ucy9zcWwvcGcvMTBfcGx1cy9jcmVhdGUuc3FsIHwgICAxICsKLi4uL3RlbXBsYXRlcy90YWJs
ZXMvc3FsLzEwX3BsdXMvc2NoZW1hX2RpZmYuc3FsICAgfCAgMTQgKwouLi4vZGF0YWJhc2VzL3Nj
aGVtYXMvdGFibGVzL3RyaWdnZXJzL19faW5pdF9fLnB5ICB8IDExNiArKy0KLi4uL2RhdGFiYXNl
cy9zY2hlbWFzL3RhYmxlcy90cmlnZ2Vycy91dGlscy5weSAgICAgfCAgMTcgKy0KLi4uL3NlcnZl
cnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3V0aWxzLnB5ICAgICAgfCAxMTMgKystCi4uLi9z
ZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3R5cGVzL19faW5pdF9fLnB5ICAgIHwgIDYxICstCi4u
Li9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3V0aWxzLnB5ICAgICAgICAgICAgIHwgMTQ4ICsr
LS0KLi4uL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdmlld3MvX19pbml0X18ucHkgICAgfCAy
MjcgKysrKystCi4uLi90ZW1wbGF0ZXMvdmlld3MvcGcvOS4yX3BsdXMvc3FsL3VwZGF0ZS5zcWwg
ICAgIHwgICAyICstCi4uLi90ZW1wbGF0ZXMvdmlld3MvcGcvOS4zX3BsdXMvc3FsL3VwZGF0ZS5z
cWwgICAgIHwgICAyICstCi4uLi90ZW1wbGF0ZXMvdmlld3MvcGcvOS40X3BsdXMvc3FsL3VwZGF0
ZS5zcWwgICAgIHwgICAyICstCi4uLi9kYXRhYmFzZXMvdGVtcGxhdGVzL2RhdGFiYXNlcy9jc3Mv
ZGF0YWJhc2UuY3NzIHwgICA1ICsKd2ViL3BnYWRtaW4vc3RhdGljL2J1bmRsZS9zbGlja2dyaWQu
anMgICAgICAgICAgICAgfCAgIDMgKwp3ZWIvcGdhZG1pbi9zdGF0aWMvanMvYmFja2Zvcm0ucGdh
ZG1pbi5qcyAgICAgICAgICB8ICAgOSArLQouLi4vc3RhdGljL3Njc3MvcmVzb3VyY2VzL19kZWZh
dWx0LnZhcmlhYmxlcy5zY3NzICB8ICAgNyArCi4uLi90b29scy9kYXRhZ3JpZC9zdGF0aWMvanMv
c2hvd19xdWVyeV90b29sLmpzICAgIHwgIDE5ICsKLi4uL3Rvb2xzL2RhdGFncmlkL3RlbXBsYXRl
cy9kYXRhZ3JpZC9pbmRleC5odG1sICAgfCAgIDkgKwp3ZWIvcGdhZG1pbi90b29scy9zY2hlbWFf
ZGlmZi9fX2luaXRfXy5weSAgICAgICAgICB8IDYwMSArKysrKysrKysrKysrKysKd2ViL3BnYWRt
aW4vdG9vbHMvc2NoZW1hX2RpZmYvY29tcGFyZS5weSAgICAgICAgICAgfCAyMTIgKysrKysrCndl
Yi9wZ2FkbWluL3Rvb2xzL3NjaGVtYV9kaWZmL2RpcmVjdG9yeV9jb21wYXJlLnB5IHwgMjc5ICsr
KysrKysKd2ViL3BnYWRtaW4vdG9vbHMvc2NoZW1hX2RpZmYvbW9kZWwucHkgICAgICAgICAgICAg
fCAgNzYgKysKd2ViL3BnYWRtaW4vdG9vbHMvc2NoZW1hX2RpZmYvbm9kZV9yZWdpc3RyeS5weSAg
ICAgfCAgNjEgKysKLi4uL3Rvb2xzL3NjaGVtYV9kaWZmL3N0YXRpYy9jc3Mvc2NoZW1hX2RpZmYu
Y3NzICAgfCAxODkgKysrKysKLi4uL3Rvb2xzL3NjaGVtYV9kaWZmL3N0YXRpYy9pbWcvY29tcGFy
ZS13aGl0ZS5zdmcgfCAgMTUgKwouLi4vdG9vbHMvc2NoZW1hX2RpZmYvc3RhdGljL2ltZy9jb21w
YXJlLnN2ZyAgICAgICB8ICAxNSArCi4uLi90b29scy9zY2hlbWFfZGlmZi9zdGF0aWMvaW1nL3Nj
cmlwdC5zdmcgICAgICAgIHwgIDE5ICsKLi4uL3NjaGVtYV9kaWZmL3N0YXRpYy9qcy9zY2hlbWFf
ZGlmZi5iYWNrZm9ybS5qcyAgfCA1MDAgKysrKysrKysrKysrCi4uLi90b29scy9zY2hlbWFfZGlm
Zi9zdGF0aWMvanMvc2NoZW1hX2RpZmYuanMgICAgIHwgMTQ1ICsrKysKLi4uL3NjaGVtYV9kaWZm
L3N0YXRpYy9qcy9zY2hlbWFfZGlmZl9ob29rLmpzICAgICAgfCAgMzggKwouLi4vdG9vbHMvc2No
ZW1hX2RpZmYvc3RhdGljL2pzL3NjaGVtYV9kaWZmX3VpLmpzICB8IDg0NSArKysrKysrKysrKysr
KysrKysrKysKLi4uL3NjaGVtYV9kaWZmL3N0YXRpYy9zY3NzL19zY2hlbWFfZGlmZi5zY3NzICAg
ICAgfCAgODUgKysrCi4uLi9zY2hlbWFfZGlmZi90ZW1wbGF0ZXMvc2NoZW1hX2RpZmYvaW5kZXgu
aHRtbCAgIHwgIDMxICsKd2ViL3BnYWRtaW4vdG9vbHMvc2NoZW1hX2RpZmYvdGVzdHMvX19pbml0
X18ucHkgICAgfCAgIDAKLi4uL3Rvb2xzL3NjaGVtYV9kaWZmL3Rlc3RzL3BnLzEwX3BsdXMvc291
cmNlLnNxbCAgfCA0NDAgKysrKysrKysrKysKLi4uL3Rvb2xzL3NjaGVtYV9kaWZmL3Rlc3RzL3Bn
LzEwX3BsdXMvdGFyZ2V0LnNxbCAgfCA0MjkgKysrKysrKysrKysKLi4uL3Rvb2xzL3NjaGVtYV9k
aWZmL3Rlc3RzL3BnLzExX3BsdXMvc291cmNlLnNxbCAgfCA0MzkgKysrKysrKysrKysKLi4uL3Rv
b2xzL3NjaGVtYV9kaWZmL3Rlc3RzL3BnLzExX3BsdXMvdGFyZ2V0LnNxbCAgfCA0MjggKysrKysr
KysrKysKLi4uL3Rvb2xzL3NjaGVtYV9kaWZmL3Rlc3RzL3BnLzEyX3BsdXMvc291cmNlLnNxbCAg
fCA0NDAgKysrKysrKysrKysKLi4uL3Rvb2xzL3NjaGVtYV9kaWZmL3Rlc3RzL3BnLzEyX3BsdXMv
dGFyZ2V0LnNxbCAgfCA0MTcgKysrKysrKysrKwouLi4vdG9vbHMvc2NoZW1hX2RpZmYvdGVzdHMv
cGcvOS4yX3BsdXMvc291cmNlLnNxbCB8IDMxMSArKysrKysrKwouLi4vdG9vbHMvc2NoZW1hX2Rp
ZmYvdGVzdHMvcGcvOS4yX3BsdXMvdGFyZ2V0LnNxbCB8IDMzNyArKysrKysrKwouLi4vc2NoZW1h
X2RpZmYvdGVzdHMvcHBhcy8xMF9wbHVzL3NvdXJjZS5zcWwgICAgICB8IDM3NiArKysrKysrKysK
Li4uL3NjaGVtYV9kaWZmL3Rlc3RzL3BwYXMvMTBfcGx1cy90YXJnZXQuc3FsICAgICAgfCAzNjQg
KysrKysrKysrCi4uLi9zY2hlbWFfZGlmZi90ZXN0cy9wcGFzLzkuMl9wbHVzL3NvdXJjZS5zcWwg
ICAgIHwgMzExICsrKysrKysrCi4uLi9zY2hlbWFfZGlmZi90ZXN0cy9wcGFzLzkuMl9wbHVzL3Rh
cmdldC5zcWwgICAgIHwgMzM3ICsrKysrKysrCi4uLi9zY2hlbWFfZGlmZi90ZXN0cy90ZXN0X3Nj
aGVtYV9kaWZmX2NvbXAucHkgICAgIHwgMjA0ICsrKysrCndlYi9wZ2FkbWluL3Rvb2xzL3NjaGVt
YV9kaWZmL3Rlc3RzL3V0aWxzLnB5ICAgICAgIHwgMTAzICsrKwp3ZWIvcGdhZG1pbi90b29scy9z
cWxlZGl0b3Ivc3RhdGljL2pzL3NxbGVkaXRvci5qcyB8ICAgOCArCi4uLi9zcWxlZGl0b3Ivc3Fs
L2RlZmF1bHQvcHJpbWFyeV9rZXlzLnNxbCAgICAgICAgIHwgICAyICstCi4uLi90b29scy9zcWxl
ZGl0b3IvdXRpbHMvZ2V0X2NvbHVtbl90eXBlcy5weSAgICAgIHwgIDExICstCndlYi9wZ2FkbWlu
L3V0aWxzL2NzcmYucHkgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAyICsKd2ViL3dlYnBh
Y2suY29uZmlnLmpzICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDQgKy0Kd2ViL3dl
YnBhY2suc2hpbS5qcyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDIgKwo4NyBm
aWxlcyBjaGFuZ2VkLCAxMDcxNyBpbnNlcnRpb25zKCspLCAzOTIgZGVsZXRpb25zKC0pCgo=

--===============4246082258930727498==--