pg_dump compatibility level / use create view instead of create table/rule
Alex Williams <[email protected]> Wed, 09 Oct 2019 01:01:39 +0000
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <NFqxoEi7-8Rw9OW0f-GwHcjvS2I4YQXov4g9OoWv3i7lVOZdLWkAWl9jQQqwEaUq6WV0vdobromhW82e8y5I0_59yZTXcZnXsrmFuldlmZc=@protonmail.com> |
This is a multi-part message in MIME format. --b1_6e34a7b80af21ffdf46d9fee8244b788 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 SGksCgpDYW4gc29tZW9uZSBsZXQgbWUga25vdyB3aGVuIHlvdSdyZSBkb2luZyBhIHBnX2R1bXAs IGNhbiB5b3Ugc3BlY2lmeSBub3QgdG8gdXNlIHRoZSB2aWV3IHJ1bGVzIHNvIHRoYXQgdGhlIHN0 YXRlbWVudCBpbiB0aGUgcGdfZHVtcCBmaWxlIHVzZXMgY3JlYXRlIHZpZXcgaW5zdGVhZCBvZiBj cmVhdGUgdGFibGUvY3JlYXRlIHJ1bGU/IFdlIGFyZSBub3QgdXNpbmcgYW55dGhpbmcgc3BlY2lm aWMgdG8gOS41IGxpa2UganNvbmIgY29sdW1ucywgc28gdGhlIERETCBzaG91bGQgYmUgY29tcGF0 aWJsZSBiZXR3ZWVuIHZlcnNpb25zIHdoZW4gY3JlYXRpbmcgLyBkZWZpbmluZyBvYmplY3RzLCBp dCBqdXN0IHRoZSB3YXkgaXQncyBjcmVhdGluZyB0aGVtIHRoYXQgaGFzIGNoYW5nZWQgd2hpY2gg aXMgY2F1c2luZyB1cyBhbiBpc3N1ZS4KCldlIGR1bXAgZnJvbSA5LjUuNSBhbmQgcmVzdG9yZSB0 byBvbmUgOS41LjE4IHNlcnZlciBhbmQgdHdvIDkuMiBzZXJ2ZXJzLi4uLndlJ3ZlIGJlZW4gZG9p bmcgdGhpcyBmb3IgYXdoaWxlIGFuZCBoYWQgbm8gaXNzdWVzIHVudGlsIHJlY2VudGx5IHdpdGgg Y2VydGFpbiB2aWV3cyB0aGF0IGFyZSB0cnlpbmcgdG8gYmUgcmVzdG9yZWQgd2l0aCBydWxlIHZp ZXdzIChzb21lIHZpZXdzIGluIHRoZSBwZ19kdW1wIGZpbGUgYXJlIGNyZWF0ZWQgd2l0aCBjcmVh dGUgdmlldyBhbmQgc29tZSBieSBjcmVhdGUgdGFibGUgLyBjcmVhdGUgcnVsZSkgSSd2ZSByZWFk IHRoaXM6IGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvOS41L3J1bGVzLXZpZXdzLmh0 bWwgYnV0IGhhdmVuJ3QgZnVsbHkgdW5kZXJzdG9vZCBpdCB5ZXQgYXMgdG8gd2hlbiBpdCBhcHBs aWVzIHRoZSBjcmVhdGUgdmlldyAgdnMgY3JlYXRlIHRhYmxlL3J1bGUgc3ludGF4LCBhcyB0aGUg cGdfZHVtcCBoYXMgYSBjb21iaW5hdGlvbiBvZiBib3RoLgoKT24gdGhlIDkuNS4xOCBzZXJ2ZXIg d2hlcmUgaXQgaGFzIHRoZSBjcmVhdGUgdGFibGUgc3ludGF4IGZvciBhIHZpZXcsIGl0IGNyZWF0 ZXMgYSB0YWJsZSBpbnN0ZWFkIG9mIGEgdmlldy4KCkZvciB0aGUgOS4yLjkgc2VydmVycywgaXQg Z2VuZXJhdGVzIGVycm9yczoKCnBnX3Jlc3RvcmU6IFthcmNoaXZlciAoZGIpXSBFcnJvciBmcm9t IFRPQyBlbnRyeSAxMTI0MDsgMTI1OSA0MjcwMzE4MiBUQUJMRSB2X215X3ZpZXcgcG9zdGdyZXMK TElORSAxOTogLi4uRSBPTkxZIHZfbXlfdmlldyBSRVBMSUNBIElELi4uCiAgICBDb21tYW5kIHdh czogQ1JFQVRFIFRBQkxFIHZfbXlfdmlldygKCnBnX3Jlc3RvcmU6IFthcmNoaXZlciAoZGIpXSBF cnJvciBmcm9tIFRPQyBlbnRyeSA4NzYxMzsgMjYxOCA0MjcwMzE4NSBSVUxFIF9SRVRVUk4gcG9z dGdyZXMKICAgIENvbW1hbmQgd2FzOiBDUkVBVEUgUlVMRSAiX1JFVFVSTiIgQVMKCkFzaWRlIGZy b20gYW4gdXBncmFkZSB0byBhbGwgdGhlIHNlcnZlcnMsIGlzIHRoZXJlIGFueXdheSBpbiBwZ19k dW1wIHRvIHNldCBhIGNvbXBhdGliaWxpdHkgbGV2ZWwgd2hlbiBkdW1waW5nIHRoZSBkYXRhYmFz ZT8gSSBjaGVja2VkIGhlcmUsIGFuZCBJIGRvbid0IHRoaW5rIHRoZXJlIGlzOiBodHRwczovL3d3 dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzkuNS9hcHAtcGdkdW1wLmh0bWwKCk1hbnkgdGhhbmtzIGlu IGFkdmFuY2UuCgpBbGV4CgpPdXIgc2V0dXAgaXMgdGhlIGZvbGxvd2luZzoKMS4gU291cmNlIFBv c3RncmVzcWwgOS41IHNlcnZlciAocGdfZHVtcCBzb3VyY2UpClBvc3RncmVTUUwgOS41LjUgb24g eDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChHQ0MpIDQuNC43IDIwMTIwMzEz IChSZWQgSGF0IDQuNC43LTE3KSwgNjQtYml0CgoyLiBUd28gOS4yLjkgc2VydmVycyAod2UgcmVz dG9yZSB0bykKUG9zdGdyZVNRTCA5LjIuOSBvbiB4ODZfNjQtcmVkaGF0LWxpbnV4LWdudSwgY29t cGlsZWQgYnkgZ2NjIChHQ0MpIDQuOC4yIDIwMTQwMTIwIChSZWQgSGF0IDQuOC4yLTE2KSwgNjQt Yml0CgozLiBPbmUgOS41ICAod2UgcmVzdG9yZSB0bykKUG9zdGdyZVNRTCA5LjUuMTggb24geDg2 XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChHQ0MpIDQuNC43IDIwMTIwMzEzCihS ZWQgSGF0IDQuNC43LTIzKSwgNjQtYml0CgpTZW50IHdpdGggW1Byb3Rvbk1haWxdKGh0dHBzOi8v cHJvdG9ubWFpbC5jb20pIFNlY3VyZSBFbWFpbC4= --b1_6e34a7b80af21ffdf46d9fee8244b788 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdj5IaSw8YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5DYW4gc29tZW9uZSBsZXQgbWUg a25vdyB3aGVuIHlvdSdyZSBkb2luZyBhIHBnX2R1bXAsIGNhbiB5b3Ugc3BlY2lmeSBub3QgdG8g dXNlIHRoZSB2aWV3IHJ1bGVzIHNvIHRoYXQgdGhlIHN0YXRlbWVudCBpbiB0aGUgcGdfZHVtcCBm aWxlIHVzZXMgY3JlYXRlIHZpZXcgaW5zdGVhZCBvZiBjcmVhdGUgdGFibGUvY3JlYXRlIHJ1bGU/ IFdlIGFyZSBub3QgdXNpbmcgYW55dGhpbmcgc3BlY2lmaWMgdG8gOS41IGxpa2UganNvbmIgY29s dW1ucywgc28gdGhlIERETCBzaG91bGQgYmUgY29tcGF0aWJsZSBiZXR3ZWVuIHZlcnNpb25zIHdo ZW4gY3JlYXRpbmcgLyBkZWZpbmluZyBvYmplY3RzLCBpdCBqdXN0IHRoZSB3YXkgaXQncyBjcmVh dGluZyB0aGVtIHRoYXQgaGFzIGNoYW5nZWQgd2hpY2ggaXMgY2F1c2luZyB1cyBhbiBpc3N1ZS48 YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5XZSBkdW1wIGZyb20gOS41LjUgYW5kIHJlc3Rv cmUgdG8gb25lIDkuNS4xOCBzZXJ2ZXIgYW5kIHR3byA5LjIgc2VydmVycy4uLi53ZSd2ZSBiZWVu IGRvaW5nIHRoaXMgZm9yIGF3aGlsZSBhbmQgaGFkIG5vIGlzc3VlcyB1bnRpbCByZWNlbnRseSB3 aXRoIGNlcnRhaW4gdmlld3MgdGhhdCBhcmUgdHJ5aW5nIHRvIGJlIHJlc3RvcmVkIHdpdGggcnVs ZSB2aWV3cyAoc29tZSB2aWV3cyBpbiB0aGUgcGdfZHVtcCBmaWxlIGFyZSBjcmVhdGVkIHdpdGgg Y3JlYXRlIHZpZXcgYW5kIHNvbWUgYnkgY3JlYXRlIHRhYmxlIC8gY3JlYXRlIHJ1bGUpIEkndmUg cmVhZCB0aGlzOiA8YSBocmVmPSJodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzkuNS9y dWxlcy12aWV3cy5odG1sIj5odHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzkuNS9ydWxl cy12aWV3cy5odG1sPC9hPiBidXQgaGF2ZW4ndCBmdWxseSB1bmRlcnN0b29kIGl0IHlldCBhcyB0 byB3aGVuIGl0IGFwcGxpZXMgdGhlIGNyZWF0ZSB2aWV3Jm5ic3A7IHZzIGNyZWF0ZSB0YWJsZS9y dWxlIHN5bnRheCwgYXMgdGhlIHBnX2R1bXAgaGFzIGEgY29tYmluYXRpb24gb2YgYm90aC48YnI+ PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5PbiB0aGUgOS41LjE4IHNlcnZlciB3aGVyZSBpdCBo YXMgdGhlIGNyZWF0ZSB0YWJsZSBzeW50YXggZm9yIGEgdmlldywgaXQgY3JlYXRlcyBhIHRhYmxl IGluc3RlYWQgb2YgYSB2aWV3LiA8YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5Gb3IgdGhl IDkuMi45IHNlcnZlcnMsIGl0IGdlbmVyYXRlcyBlcnJvcnM6IDxicj48L2Rpdj48ZGl2Pjxicj48 L2Rpdj48ZGl2PnBnX3Jlc3RvcmU6IFthcmNoaXZlciAoZGIpXSBFcnJvciBmcm9tIFRPQyBlbnRy eSAxMTI0MDsgMTI1OSA0MjcwMzE4MiBUQUJMRSB2X215X3ZpZXcgcG9zdGdyZXM8YnI+PC9kaXY+ PGRpdj5MSU5FIDE5OiAuLi5FIE9OTFkgdl9teV92aWV3IFJFUExJQ0EgSUQuLi48L2Rpdj48ZGl2 PiZuYnNwOyZuYnNwOyZuYnNwOyBDb21tYW5kIHdhczogQ1JFQVRFIFRBQkxFIHZfbXlfdmlldyg8 L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PnBnX3Jlc3RvcmU6IFthcmNoaXZlciAoZGIpXSBFcnJv ciBmcm9tIFRPQyBlbnRyeSA4NzYxMzsgMjYxOCA0MjcwMzE4NSBSVUxFIF9SRVRVUk4gcG9zdGdy ZXM8YnI+PC9kaXY+PGRpdj4mbmJzcDsmbmJzcDsmbmJzcDsgQ29tbWFuZCB3YXM6IENSRUFURSBS VUxFICJfUkVUVVJOIiBBUzxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PkFzaWRlIGZyb20g YW4gdXBncmFkZSB0byBhbGwgdGhlIHNlcnZlcnMsIGlzIHRoZXJlIGFueXdheSBpbiBwZ19kdW1w IHRvIHNldCBhIGNvbXBhdGliaWxpdHkgbGV2ZWwgd2hlbiBkdW1waW5nIHRoZSBkYXRhYmFzZT8g SSBjaGVja2VkIGhlcmUsIGFuZCBJIGRvbid0IHRoaW5rIHRoZXJlIGlzOiA8YSBocmVmPSJodHRw czovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzkuNS9hcHAtcGdkdW1wLmh0bWwiPmh0dHBzOi8v d3d3LnBvc3RncmVzcWwub3JnL2RvY3MvOS41L2FwcC1wZ2R1bXAuaHRtbDwvYT48YnI+PC9kaXY+ PGRpdj48YnI+PC9kaXY+PGRpdj5NYW55IHRoYW5rcyBpbiBhZHZhbmNlLjxicj48L2Rpdj48ZGl2 Pjxicj48L2Rpdj48ZGl2PkFsZXg8YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5PdXIgc2V0 dXAgaXMgdGhlIGZvbGxvd2luZzo8YnI+PC9kaXY+PGRpdj4xLiBTb3VyY2UgUG9zdGdyZXNxbCA5 LjUgc2VydmVyIChwZ19kdW1wIHNvdXJjZSk8YnI+PC9kaXY+PGRpdj5Qb3N0Z3JlU1FMIDkuNS41 IG9uIHg4Nl82NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdjYyAoR0NDKSA0LjQuNyAyMDEy MDMxMyAoUmVkIEhhdCA0LjQuNy0xNyksIDY0LWJpdDxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48 ZGl2PjIuIFR3byA5LjIuOSBzZXJ2ZXJzICh3ZSByZXN0b3JlIHRvKTxicj48L2Rpdj48ZGl2PlBv c3RncmVTUUwgOS4yLjkgb24geDg2XzY0LXJlZGhhdC1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdj YyAoR0NDKSA0LjguMiAyMDE0MDEyMCAoUmVkIEhhdCA0LjguMi0xNiksIDY0LWJpdDxicj48L2Rp dj48ZGl2Pjxicj48L2Rpdj48ZGl2PjMuIE9uZSA5LjUmbmJzcDsgKHdlIHJlc3RvcmUgdG8pPGJy PjwvZGl2PjxkaXY+UG9zdGdyZVNRTCA5LjUuMTggb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29t cGlsZWQgYnkgZ2NjIChHQ0MpIDQuNC43IDIwMTIwMzEzPGJyPjwvZGl2PjxkaXY+KFJlZCBIYXQg NC40LjctMjMpLCA2NC1iaXQ8YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+ PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PC9k aXY+PGRpdiBjbGFzcz0icHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2siPjxkaXYgY2xhc3M9InBy b3Rvbm1haWxfc2lnbmF0dXJlX2Jsb2NrLXVzZXIgcHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2st ZW1wdHkiPjxicj48L2Rpdj48ZGl2IGNsYXNzPSJwcm90b25tYWlsX3NpZ25hdHVyZV9ibG9jay1w cm90b24iPlNlbnQgd2l0aCA8YSBocmVmPSJodHRwczovL3Byb3Rvbm1haWwuY29tIiB0YXJnZXQ9 Il9ibGFuayI+UHJvdG9uTWFpbDwvYT4gU2VjdXJlIEVtYWlsLjxicj48L2Rpdj48L2Rpdj48ZGl2 Pjxicj48L2Rpdj4= --b1_6e34a7b80af21ffdf46d9fee8244b788--