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 example
> 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
Place your commands in a file & execute them either from the prompt or
from psql. Remember to create your file in the below order:
1) create database
2) c
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 i