Postgres Pro
Downloads
Home   >   mailing lists

How to synchronize tables in remote (production) and local databases in case if the structure of local database's table has been modified - Mailing list pgsql-general

From Vitaly Isaev
Subject How to synchronize tables in remote (production) and local databases in case if the structure of local database's table has been modified
Date
Msg-id 1002811412754541@web21m.yandex.ru
Whole thread Raw
Responses Re: How to synchronize tables in remote (production) and local databases in case if the structure of local database's table has been modified  (Sergey Konoplev <gray.ru@gmail.com>)
Re: How to synchronize tables in remote (production) and local databases in case if the structure of local database's table has been modified  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general
Tree view 
PGRpdj5IZWxsbyw8L2Rpdj48ZGl2Ppo8L2Rpdj48ZGl2PkkgaGF2ZSBmYWNlZCB3aXRoIGEgY29t
cGxpY2F0ZWQgY2FzZSBvZiB0YWJsZSBzeW5jaHJvbmlzYXRpb24uIFRoZSBmdWxsIGRlc2NyaXB0
aW9uIG9mIHRoZSBwcm9ibGVtICh3aXRoIHNvbWUgZmlndXJlcykgaXMgcG9zdGVkIGhlcmU6IGh0
dHA6Ly9zdGFja292ZXJmbG93LmNvbS9xdWVzdGlvbnMvMjYyMzc2NjEvcG9zdGdyZXNxbC11cGRh
dGUtdGFibGUtd2l0aC1uZXctcmVjb3Jkcy1mcm9tLXRoZS1zYW1lLXRhYmxlLW9uLXJlbW90ZS1z
ZXJ2ZXI8L2Rpdj48ZGl2Ppo8L2Rpdj48ZGl2PkhlcmUgaXQgdGhlIHBhcnRpYWwgcmVwb3N0IG9m
IG15IHN0YWNrb3dlcmZsb3cncyB0b3BpYzo8L2Rpdj48ZGl2Ppo8L2Rpdj48YmxvY2txdW90ZT48
ZGl2PldlIGhhdmUgYSBQb3N0Z3JlU1FMIHNlcnZlciBydW5uaW5nIGluIHByb2R1Y3Rpb24gYW5k
IGEgcGxlbnR5IG9mIHdvcmtzdGF0aW9ucyB3aXRoIGFuIGlzb2xhdGVkIGRldmVsb3BtZW50IGVu
dmlyb25tZW50cy4gRWFjaCBvbmUgaGFzIGl0cyBvd24gbG9jYWwgUG9zdGdyZVNRTCBzZXJ2ZXIg
KHdpdGggbm8gcmVwbGljYXRpb24gd2l0aCB0aGUgcHJvZHVjdGlvbiBzZXJ2ZXIpLiBEZXZlbG9w
ZXJzIG5lZWQgdG8gcmVjZWl2ZSB1cGRhdGVzIHN0b3JlZCBpbiBwcm9kdWN0aW9uIHNlcnZlciBw
ZXJpb2RpY2FsbHkuPC9kaXY+PGRpdj6aPC9kaXY+PGRpdj5JIGFtIHRyeWluZyB0byBmaWd1cmUg
b3V0IGhvdyB0byBkdW1wIHRoZSBjb250ZW50cyBvZiBzZXZlcmFsIHNlbGVjdGVkIHRhYmxlcyBm
cm9tIHNlcnZlciBpbiBvcmRlciB0byB1cGRhdGUgdGhlIHRhYmxlcyBvbiBkZXZlbG9wbWVudCB3
b3Jrc3RhdGlvbnMuIFRoZSBiaWdnZXN0IGNoYWxsZW5nZSBpcyB0aGF0IHRoZSB0YWJsZXMgSSdt
IHRyeWluZyB0byBzeW5jaHJvbml6ZSBtYXkgYmUgZGl2ZXJnZWQgKGRldmVsb3BlcnMgbWF5IGFk
ZCAtIGJ1dCBub3QgZGVsZXRlIC0gbmV3IGZpZWxkcyB0byB0aGUgdGFibGVzIHRocm91Z2ggdGhl
IERqYW5nbyBPUk0sIHdoaWxlIHNjaGVtYSBvZiB0aGUgcHJvZHVjdGlvbiBkYXRhYmFzZSByZW1h
aW5zIHVuY2hhbmdlZCBmb3IgYSBsb25nIHRpbWUpLjwvZGl2PjwvYmxvY2txdW90ZT48ZGl2Pjxi
bG9ja3F1b3RlPjxwPlRoZXJlZm9yZSB0aGUgdXBkYXRlZCByZWNvcmRzIGFuZCBuZXcgZmllbGRz
IG9mIHRoZSB0YWJsZXMgc3RvcmVkIG9uIHdvcmtzdGF0aW9ucyA8ZW0+bXVzdCBiZTwvZW0+IHBy
ZXNlcnZlZCBhZ2FpbnN0IHRoZSBvdmVyd3JpdGluZy48L3A+PHA+SSBndWVzcyB0aGF0IGRpcmVj
dCBkdW1wcyAoZS5nLiBwZ19kdW1wIC1VIHJlbW90ZV91c2VyIC1oIHJlbW90ZV9zZXJ2ZXIgLXQg
dGFibGVfdG9fY29weSBzb3VyY2VfZGIgfCBwc3FsIHRhcmdldF9kYikgYXJlIG5vdCBzdWl0YWJs
ZSBoZXJlLjwvcD48cD48c3Ryb25nPlVQRDwvc3Ryb25nPjogSWYgcG9zc2libGUgSSB3b3VsZCBh
bHNvIGxpa2UgdG8gYXZvaWQgdGhlIHVzZSBvZiB0aGlyZCAoaW50ZXJtZWRpYXRlKSBkYXRhYmFz
ZSB3aGlsZSB0cmFuc2ZlcnJpbmcgdGhlIGRhdGEgZnJvbSBwcm9kdWN0aW9uIGRhdGFiYXNlIHRv
IHRoZSB3b3Jrc3RhdGlvbnMuPC9wPjwvYmxvY2txdW90ZT48L2Rpdj48ZGl2Ppo8L2Rpdj48ZGl2
PkhhdmUgbm8gaWRlYSBob3cgdG8gd29yayBpdCBvdXQuIEFueSBoZWxwIHdpbGwgYmUgYXBwcmVj
aWF0ZWQuPC9kaXY+PGRpdj5TaW5jZXJlbHksPC9kaXY+PGRpdj4tLZo8L2Rpdj48ZGl2PlZpdGFs
eSBJc2FldjwvZGl2PjxkaXY+c29mdHdhcmUgZW5nZW5lZXI8L2Rpdj48ZGl2PlRlYW0xMTIucnU8
L2Rpdj48ZGl2Ppo8L2Rpdj4=

pgsql-general by date:

Previous
From: "Bricklen Anderson"
Date:
Subject: From: Bricklen Anderson
Next
From: "Andrus"
Date:
Subject: Re: Converting char to varchar automatically