Re: Batch Definitions - Need Help

"Michael Avila" <mavila@mich.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.

Either
psql mydb <batchfile
or
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
should work.

            regards, tom lane