On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote: > This is going to be an amateur question... > > Could somebody explain me, or point me to a resource where I can find > out what is the recommended practice when a live db needs to be replaced > with a new version of it that has a slightly different structure? > > My first guess would be to create the empty new version of the db and > insert the data of the old one into it - adding and modifying it when > necessary, but I am not sure. > > What do you usually do in a situation like this?
ALTER TABLE ... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
