> 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.
That or just separate commands by a semi colon:
select * from table1; select * from table2;
-
Hi,
I am not sure what's your question.
However, you can list a bunch of SQL statements in a text file:
e.g.
myfile.sql which contains:
select * from tablename where
update tablename set ... where ...
.
then, you can just run it like:
psql -q dbname < myfile.sql
Jie LIANG
St. Be
I just put files commands that I want in some file
like "foo.sql" and then do:
psql mydatabase -f foo.sql
Is this what you are looking for?
Jason
--- Milen <[EMAIL PROTECTED]> wrote:
> Hi all!,
>
> I want to execute several SQL statements one after
> another.
> Does anyone know if it is pos
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.
Best Regards:
Milen
---(end of broadcast)---
TIP 5: Have you c
