I'm coming over from MySQL. I'm running SUSE Linux 9.2, running PGSQL 7.4.8.
In MySQL, I could use a simple batch file to run all my table creation
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?
Or is this why there are a dozen languages for server programming? If
redirecting the input from a batchfile is possible, please point me to
the right documentation.. If not, I'll go back to the languages
section of the manual. Many thanks in advance.
DC Parris GNU Evangelist
Free software is like God's love -
you can share it with anyone anywhere anytime!
pgsql-novice by date
|Next:||From: Kirsten Wahlstrom||Date: 2005-07-14 07:05:31|
|Subject: rowtypes and functions|
|Previous:||From: Keith Worthington||Date: 2005-07-14 04:34:07|
|Subject: Re: view data types|