"Michael Avila" <mavila(at)mich(dot)com> writes:
> Oppps! I forgot only one word in my description - BATCH. Apologies. Makes a
> BIG difference.
> I want to load table definitions and insert data from a batch file. The
> batch file was created from a MySQL database so I know I will have to make
> some changes.
psql mydb <batchfile
psql -f batchfile mydb
... edit out MySQL-isms, lather rinse repeat ...
I don't know exactly what a MySQL batch file looks like, in particular
whether they do anything nonstandard for bulk data load. To the extent
that the file contains reasonably-standard SQL commands, though, it
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Greg Sabino Mullane||Date: 2005-06-14 03:27:06|
|Subject: Re: Wrong SQLSTATE returned?|
|Previous:||From: Michael Avila||Date: 2005-06-13 23:37:19|
|Subject: Re: Batch Definitions - Need Help|