Using Batch Files to Create DB Structure

Поиск
Список
Период
Сортировка
От Don Parris
Тема Using Batch Files to Create DB Structure
Дата
Msg-id 669261440507132255681c520a@mail.gmail.com
обсуждение исходный текст
Ответы Re: Using Batch Files to Create DB Structure  (brew@theMode.com)
Re: Using Batch Files to Create DB Structure  (John DeSoi <desoi@pgedit.com>)
Список pgsql-novice
Greetings,

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
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?

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.

Don
--
DC Parris GNU Evangelist
http://matheteuo.org/
gnumathetes@gmail.com
Free software is like God's love -
you can share it with anyone anywhere anytime!

В списке pgsql-novice по дате отправления:

Предыдущее
От: Keith Worthington
Дата:
Сообщение: Re: view data types
Следующее
От: brew@theMode.com
Дата:
Сообщение: Re: Using Batch Files to Create DB Structure