X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7C15E9FB2B7 for ; Wed, 16 Aug 2006 04:12:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 76314-09 for ; Wed, 16 Aug 2006 07:12:32 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from scrih10.sipic.com (scrih10.sipic.com [83.206.120.220]) by postgresql.org (Postfix) with ESMTP id C18099FB1F8 for ; Wed, 16 Aug 2006 04:12:31 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by scrih10.sipic.com (messagerie) with ESMTP id 15BFD38A2B for ; Wed, 16 Aug 2006 09:12:35 +0200 (CEST) Received: from scrih10.sipic.com ([127.0.0.1]) by localhost (scrih10 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22919-08 for ; Wed, 16 Aug 2006 09:12:34 +0200 (CEST) Received: from [126.200.0.8] (w80208.sipic.com [126.200.0.8]) by scrih10.sipic.com (messagerie) with ESMTP id B990638839 for ; Wed, 16 Aug 2006 09:12:34 +0200 (CEST) Message-ID: <44E2C5A9.4070505@sihpic.fr> Date: Wed, 16 Aug 2006 09:13:45 +0200 From: Soulabaille Samantha User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: two databases in one Content-Type: multipart/mixed; boundary="------------080507070201090407020809" X-Virus-Scanned: amavisd-new at sihpic.fr X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/183 X-Sequence-Number: 22726 This is a multi-part message in MIME format. --------------080507070201090407020809 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello, I'm working with a postgresql 7.4.7 I've got two databases with the same tables and schema on two different servers. I want to have only one database. So i would like to insert in the first database the data of the second database. I don't know how to do this because almost of the tables contains serial. It's for production databases, i can't make mistakes. Can anyone help me? It's urgent. Thanks --------------080507070201090407020809 Content-Type: text/x-vcard; charset=utf-8; name="samantha.soulabaille.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="samantha.soulabaille.vcf" begin:vcard fn:Samantha Soulabaille n:Soulabaille;Samantha org:SIHPIC adr;dom:;;43 avenue d'Italie;amiens;;80094 cedex 3 email;internet:samantha.soulabaille@sihpic.fr x-mozilla-html:FALSE version:2.1 end:vcard --------------080507070201090407020809--