How can I merge two tables?
От | Jerry LeVan |
---|---|
Тема | How can I merge two tables? |
Дата | |
Msg-id | DAF8B412-1161-4FA0-80B4-461B424F83D0@gmail.com обсуждение исходный текст |
Ответы |
Re: How can I merge two tables?
Re: How can I merge two tables? Re: How can I merge two tables? |
Список | pgsql-general |
Hi, I have tables on my various computers that looks like: Table "public.registrations" Column | Type | Modifiers | Storage | Description ----------+------+-----------+----------+------------- software | text | | extended | id | text | | extended | value | text | | extended | location | text | | extended | Indexes: "registrations_software_idx" btree (software) CLUSTER Has OIDs: yes I keep registration numbers for software and login/passwords for various organizations, etc… As time goes by the tables on the various computers get out of sync. Is there an elegant way I can get all of the differences (uniquely) merged into a single table? Thanks Jerry
В списке pgsql-general по дате отправления: