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

Поиск
Список
Период
Сортировка
От Vitaly Isaev
Тема How to synchronize tables in remote (production) and local databases in case if the structure of local database's table has been modified
Дата
Msg-id 1002811412754541@web21m.yandex.ru
обсуждение исходный текст
Ответы 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>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: "Bricklen Anderson"
Дата:
Сообщение: From: Bricklen Anderson
Следующее
От: "Andrus"
Дата:
Сообщение: Re: Converting char to varchar automatically