Re: pg_dump question - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump question
Date
Msg-id 17034.1099516743@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump question  ("Andrei Bintintan" <klodoma@ar-sd.net>)
List pgsql-admin
"Andrei Bintintan" <klodoma@ar-sd.net> writes:
> 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

I don't actually believe that --- simple inspection of the pg_dump
source shows that it can never emit an ALTER TABLE ADD COLUMN command.

Can you give a concrete example of what you are talking about?

            regards, tom lane

pgsql-admin by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: Postgresql beta4 rpms
Next
From: Joe Conway
Date:
Subject: Re: Postgresql beta4 rpms