Thread: help me!!

help me!!

From
"XIE, Rong"
Date:
Hello,
 
My name is rong xie. I am a Student at TU-Munich.
I have a question to Postgresql an Linux.
e.g:
for IBM DB2: I can write a test.sql file.
 
--test.sql
connect to database1;
set schema xie;
select * from table1;
insert table1 value('rong','xie',22);
select * from table1;
terminate;
 
Then I can execute the file "test.sql" in terminal.
db2 -tvf test.sql
 
In mysql: I can execute it so.
mysql > test.sql
 
How can I execute it in Postgresql?
is there similar command in linux for Postgresql?
 
Thank you very mach!
 
Best wish!
 
rong xie