Received: from mail.tnet.es ([195.76.49.3]) by hub.org (8.9.1/8.9.1) with SMTP id TAA20635 for ; Mon, 30 Nov 1998 19:19:32 -0500 (EST) (envelope-from pvides@tnet.es) Received: from [195.57.97.162] by mail.tnet.es (SMTPD32-4.0) id A6291C50194; Tue, 01 Dec 1998 01:19:53 +0100 Sender: pax Message-ID: <3662927E.28F02FD3@tnet.es> Date: Mon, 30 Nov 1998 13:41:34 +0100 From: "PAX!" X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i586) MIME-Version: 1.0 To: Frank Morton , PostgreSQL General Subject: Re: [SQL] alter help needed References: <005f01be1b5b$3d5ecef0$8355e5ce@tesla.base2inc.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Frank Morton wrote: I think you coul do this with one select and one alter table. First you create the new table with the adecuate structure, with a temp name. You dum all the data with a select and drop the first table. Then you change the name with alter table. I hope it's useful. > > As an example, given a table with 2 columns, if I want to add > a new column "between" the already existing columns, is there > any way to use "alter table" to do this? > > The only way I can figure out how to do this and preserve the > data is to dump the database and write a script to modify > the dump by modifying the table structure plus the insert > statements reflecting the change. This seems more painful > and I must be missing an easier way to do this. > > I am trying to come up with an automated way to deal with > multiple revisions of a database structure. > > Any help? Thanks. > > _________________________________ > Frank Morton (fmorton@mail.base2inc.com) > Voice: (317) 876-3355 > FAX: (317) 876-3398 > Home: (317) 574-0815 -- La risa es la actitud primigenia hacia la vida: un modo de acercamiento que pervive sólo en criminales y artistas -- Oscar Wilde