Re: [SQL] Using sql statements in file

2003-09-23 Thread scott.marlowe
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

Re: [SQL] Using sql statements in file

2003-09-22 Thread A.Bhuvaneswaran
> 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

[SQL] Using sql statements in file

2003-09-22 Thread 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

Re: [SQL] Using sql statements in file

2003-09-22 Thread 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 i

[SQL] Using sql statements in file

2003-09-22 Thread 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