Hi, I don't think this is a good idea. But it is the thing that I have done. You'd better need a programme to read all data from old db and insert into new db.
Hope this help Lonh ----- Original Message ----- From: "Prashanth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 12, 2002 8:30 AM Subject: [ADMIN] Moving data between databases > > Hi, > > I have recovered the schema of my corrupted database. Now I > have created a new database with the tables and other schema. How can I > move the data from my old database to the new database ? > > -Venkat > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster