| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Michael Avila" <mavila(at)mich(dot)com> |
| Cc: | "Pgsql-Novice" <pgsql-novice(at)postgresql(dot)org>, KeithW(at)NarrowPathInc(dot)com |
| Subject: | Re: Batch Definitions - Need Help |
| Date: | 2005-06-14 00:45:51 |
| Message-ID: | 10723.1118709951@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2005-06-14 03:27:06 | Re: Wrong SQLSTATE returned? |
| Previous Message | Michael Avila | 2005-06-13 23:37:19 | Re: Batch Definitions - Need Help |