On Fri, Oct 22, 2010 at 07:58:20AM +0100, Chris Withers wrote: > On 21/10/2010 15:40, ringemup wrote: > >MySQL has a tool (mysqldump) that will output the contents of an > >entire database to a SQL file that can then be loaded directly into > >another database. Does Postgres not have anything analogous? > > Sure, pg_dumpall. Now, what're the chances of the SQL that spits out > being parsed correctly by MySQL without complaint? ;-)
I think the OP was referring to mysqldump's --compatible option which one could use, for example, as mysqldump --compatible=postgresql ... If pg_dumpall has a similar option chances are good it could produce SQL that MySQL would be happy with. But, I don't think pg_dumpall has such an option. -- Kevin http://www.RawFedDogs.net http://www.WacoAgilityGroup.org Bruceville, TX What's the definition of a legacy system? One that works! Errare humanum est, ignoscere caninum. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
