>>mysqldump --extended-insert=FALSE<<
Thanks for the help, this is allowing me to import the data now.
Regards,
Frank
At 09:37 AM 9/1/2005, Michael Fuhr wrote:
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion. Also, please don't top-post, as
Hi Frank;
I will use your questions to help in the next version of my migration
guide, but you might want to take a look at it anyway.
You can find it at:
http://www.metatrontech.com/wpapers/
It covers many areas of incompatibility between MySQL and PostgreSQL.
My own suggestions is that yo
Michael Fuhr wrote:
> [Please copy the mailing list on replies so others can
> contribute to and learn from the discussion. Also, please
> don't top-post, as it destroys the flow of the discussion;
> I've moved your questions to a more logical place.]
>
> On Wed, Aug 31, 2005 at 03:49:57PM -0600,
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion. Also, please don't top-post, as
it destroys the flow of the discussion; I've moved your questions
to a more logical place.]
On Wed, Aug 31, 2005 at 03:49:57PM -0600, [EMAIL PROTECTED] wrote:
> On W
:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Michael Fuhr
> Sent: Wednesday, August 31, 2005 12:39 PM
> To: Frank
> Cc: Scott Marlowe; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] newbie - postgresql or mysql
>
> On Wed, Aug 31, 2005 at 03:17:29PM -0400, Frank wrot
On Wed, 2005-08-31 at 14:17, Frank wrote:
> Thanks for clearing up some confusion.
>
> >>Look in the contrib/mysql directory in the source file (or install the
> contrib packages for your system, assuming they come with that contrib
> package<<
It comes with the postgresql tar ball. just downlo
On 8/31/05, Frank <[EMAIL PROTECTED]> 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 o
On Wed, Aug 31, 2005 at 03:17:29PM -0400, Frank wrote:
> This fails to insert records
>
> >> insert into category values
> >> (4, 'Hardware - Monitor', 2, '2004-10-12 10:50:01'),
> >> (5, 'Hardware - Printer', 2, '2004-10-12 10:50:02'),
> >> (6, 'Hardware - Terminal', 2, '2004-10-12 10:50:02'),
Frank <[EMAIL PROTECTED]> writes:
>> Look in the contrib/mysql directory in the source file (or install the
>> contrib packages for your system, assuming they come with that contrib
>> package<<
> I do not have that, where can I download it?
The best place to get it would be
http://gborg.postgres
On Wed, Aug 31, 2005 at 03:17:29PM -0400, Frank wrote:
> Thanks for clearing up some confusion.
>
> >>Look in the contrib/mysql directory in the source file (or install the
> contrib packages for your system, assuming they come with that contrib
> package<<
>
> I do not have that, where can I dow
MySQL has a nasty habit of ignoring standards; in every other database
I've used, if you want to quote an identifier (such as a field name),
you use ", not `.
The fields are also incompatable. int() is non-standard, for starters.
There are MySQL to PostgreSQL conversion tools out there that shoul
Thanks for clearing up some confusion.
>>Look in the contrib/mysql directory in the source file (or install the
contrib packages for your system, assuming they come with that contrib
package<<
I do not have that, where can I download it?
This fails to insert records
> insert into category va
On Wed, 2005-08-31 at 13:50, Frank wrote:
> Thanks for the feedback, sorry I was not more specific.
> We are a non-profit hospital and have been using MySQL for about 4 years.
>
> I wanted to convert some apps over to use postgresql and cannot find
> a good tool to import and auto create the tabl
Thanks for the feedback, sorry I was not more specific.
We are a non-profit hospital and have been using MySQL for about 4 years.
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
Hello Frank,
I believe that PostgreSQL is a proper RDBMS adhering to the ACID
principles, as well as has similar functions to Oracle, in terms of having
procedural language support with pg/plsql and the ability to also use
other languages such as perl, java (pl/perl and pl/java) to do the sam
Frank wrote:
Hello,
I would like to try postgresql and was wondering what benefits it has
over MySql.
I am using navicat to manage my MySQL databases.
Hi Frank. You don't say what you want to use your RDBMS for, so it's a
bit difficult to point out what about PostgreSQL would be best for
On Wed, Aug 31, 2005 at 11:50:55AM -0400, Frank wrote:
> I would like to try postgresql and was wondering what benefits it
> has over MySql.
Search the list archives to see past discussion, or use a search
engine like Google with words like "postgresql mysql comparison."
A couple of links you mi
Hello,
I would like to try postgresql and was wondering what benefits it
has over MySql.
I am using navicat to manage my MySQL databases.
Thanks for the help.
Frank
---(end of broadcast)---
TIP 6: explain analyze is your friend
18 matches
Mail list logo
