Re: batch file

Поиск
Список
Период
Сортировка
От harrold@sage.che.pitt.edu
Тема Re: batch file
Дата
Msg-id Pine.LNX.4.21.0105281004590.21080-100000@sage.che.pitt.edu
обсуждение исходный текст
Ответ на batch file  (Milen <milend@ansco.com>)
Список pgsql-novice
On Fri, 25 May 2001, Milen wrote:

> Hi all!
>
> I want to execute several SQL statements one after another.
> Does anyone know if it is possible to create something like a "batch file"
> which contains all SQL commands I want.
> Thank you in advance!
>
> Best regards:
> Milen
>

yeah you create a text file that has contains the commands just as you
would type them in the psql environment, making sure to end each command
with a ';'.

then at the console type:

psql db_name < batchfile

--
john


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

Предыдущее
От: Nabil Sayegh
Дата:
Сообщение: Re: inserting values like in mySQL
Следующее
От: Nabil Sayegh
Дата:
Сообщение: Re: batch file