X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DA0A33A3CA2 for ; Tue, 2 Nov 2004 14:17:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56043-08 for ; Tue, 2 Nov 2004 14:17:09 +0000 (GMT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr1.postgresql.org (Postfix) with ESMTP id 96DA23A3B53 for ; Tue, 2 Nov 2004 14:17:10 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 300011FB2F for ; Tue, 2 Nov 2004 16:19:52 +0200 (EET) Received: from ar-sd.net ([127.0.0.1]) by localhost (linz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16771-03 for ; Tue, 2 Nov 2004 16:19:51 +0200 (EET) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id 1AFC4B9BF for ; Tue, 2 Nov 2004 16:19:50 +0200 (EET) Message-ID: <007501c4c0e6$a3ffadf0$0b00a8c0@forge> From: "Andrei Bintintan" To: Subject: pg_dump question Date: Tue, 2 Nov 2004 16:17:07 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0072_01C4C0F7.65EC0C00" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200411/21 X-Sequence-Number: 15406 This is a multi-part message in MIME format. ------=_NextPart_000_0072_01C4C0F7.65EC0C00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi to all,=20 If I create a table with create table and after that I modify the = table(add some columns) in the dump the table is saved in the same way, = I mean, in the dump first the table is created and after that the column = is added.=20 Is there a possibility to dump the database and the table structure to = be saved as "it is" or always it will be dumped as created and after = that altered? Andy. ------=_NextPart_000_0072_01C4C0F7.65EC0C00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi to all,
 
If I create a table with create table = and after=20 that I modify the table(add some columns) in the dump the table is saved = in the=20 same way, I mean, in the dump first the table is created and after that = the=20 column is added.
 
Is there a possibility to dump the = database and the=20 table structure to be saved as "it is" or always it will be dumped as = created=20 and after that altered?
 
Andy.
------=_NextPart_000_0072_01C4C0F7.65EC0C00--