Re: Using Batch Files to Create DB Structure

Don....

> In MySQL, I could use a simple batch file to run all my table creation
> statements:
> mysql -u user -p mydb < /file/path/batchfile.sql
>
> Is this possible with PGSQL? Can I do this, for instance:
> psql -W mydb < /file/path/batchfile.sql
>
> and get all my tables created?

Yes.

I always have to play with it to get the command line right. And then
when loading a mysql dump into postgreSQL I have to play with it
some more.

What works best for me is to put drop table statements in at the begining
of the dump, then I keep loading it in over and over, each time
noting the errors and correcting the definitions until I get the table
defined and the data loaded.

The data types are slightly different mostly.

There is a script to go from mysql to postgreSQL somewhere, but I've never
used it. Always did it by hand.

brew

==========================================================================
Strange Brew (brew(at)theMode(dot)com)
Check out my Stock Option Covered Call website http://www.callpix.com
and my Musician's Online Database Exchange http://www.TheMode.com
==========================================================================