Alternatively, I've found this tool works very well: https://pypi.python.org/pypi/py-mysql2pgsql
(only thing to look out for are Django IPAddressFields as they are char(15) fields in MySQL and inet fields in Postgres - py-mysql2pgsql is obviously not aware of this) HTH Patrick -----Original Message----- From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Tom Evans Sent: 20 March 2013 14:12 To: django-users@googlegroups.com Subject: Re: PostgresSQL or MySql with django? On Wed, Mar 20, 2013 at 1:54 PM, frocco <faro...@gmail.com> wrote: > Hello, > > I know this is not django related, but can someone help me with the > syntax to port mysql to postgresql? > I tried the mysqldump command with the postgresql compatibility > option, but I still cannot import the data. > > Thanks > > Django itself has mechanisms for importing and exporting data in a database independent format: https://docs.djangoproject.com/en/1.5/ref/django-admin/#django-admin-dumpdata If you are not dealing with huge amounts of data, this can be the simplest way forward. Cheers Tom -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
