Re: newbie - postgresql or mysql

From: Brian Wong <bwlist(at)gmail(dot)com>
To: Frank <farocco(at)verizon(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: newbie - postgresql or mysql
Date: 2005-08-31 19:54:13
Message-ID: e1c904a40508311254591ef770@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/31/05, Frank <farocco(at)verizon(dot)net> wrote:
> I wanted to convert some apps over to use postgresql and cannot find
> a good tool to import and auto create the tables.
> MySQL syntax is not compatible with postgresql.
> I get:
> ERROR: syntax error at or near "`" at character 14
> from the MySQL output below.
>

Try playing with the mysqldump command. Some of the options alleviate
the quoting issue. Try the --quote-names=FALSE option for example.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-08-31 20:24:48 Re: newbie - postgresql or mysql
Previous Message Scott Marlowe 2005-08-31 19:49:39 Re: newbie - postgresql or mysql