Обсуждение: Using sql statements in file

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

Using sql statements in file

От
"Suresh Basandra"
Дата:

Hi,

 

I would like to do the following using files:

 

1. put create database, create tables sql statements in a file and execute through prompt

2. insert or update data that is put in a file

 

Please let me know if there are any examples that lists how sql statements can be  put in a file and used.

 

Thanks

Suresh Basandra

Re: Using sql statements in file

От
Wei Weng
Дата:
try psql -f filename


On Mon, 22 Sep 2003, Suresh Basandra wrote:

> Hi,
>  
> I would like to do the following using files:
>  
> 1. put create database, create tables sql statements in a file and
> execute through prompt
> 2. insert or update data that is put in a file
>  
> Please let me know if there are any examples that lists how sql
> statements can be  put in a file and used.
>  
> Thanks
> Suresh Basandra
>