On 28/04/2009 21:09, Joshua D. Drake wrote: > On Tue, 2009-04-28 at 12:59 -0700, Christine Penner wrote: >> After looking closer at the log file I found something interesting: > >> This backup included the table creating aswell. How can it not have a >> column in the table. Am I wrong to assume that when I restore over an >> existing database it will delete things first? It looks like it doesn't. > > No it will not delete things first. I think that would be a serious > design flaw if it did so. If you want to see how the backup and restore works, do a backup with the PLAIN option and read through the resulting SQL file. The compress/tar options produce the same output only, well, compressed/tarred. :-) Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
