Обсуждение: batch file

Поиск
Список
Период
Сортировка

batch file

От
Milen
Дата:
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

Re: batch file

От
harrold@sage.che.pitt.edu
Дата:
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


Re: batch file

От
Nabil Sayegh
Дата:
harrold@sage.che.pitt.edu wrote:
> psql db_name < batchfile

or

psql db_name -f batchfile

cu
--
 Nabil Sayegh