X-Original-To: pgadmin-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2E22C474E5C; Wed, 12 Feb 2003 05:44:17 -0500 (EST) Received: from mailrelay2.lrz-muenchen.de (mailrelay2.lrz-muenchen.de [129.187.254.102]) by postgresql.org (Postfix) with ESMTP id 2C107474E44; Wed, 12 Feb 2003 05:44:16 -0500 (EST) Received: from [138.245.10.1] by mailout.lrz-muenchen.de; Wed, 12 Feb 2003 11:44:15 +0100 Message-Id: <000801c2d283$564c39a0$d2e0f48a@ips64m> From: "XIE, Rong" To: <"Undisclosed-Recipient:;"@postgresql.org> Subject: help me!! Date: Wed, 12 Feb 2003 11:41:44 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C2D28B.B7CBD070" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/26 X-Sequence-Number: 754 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C2D28B.B7CBD070 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello,=20 My name is rong xie. I am a Student at TU-Munich. I have a question to Postgresql an Linux.=20 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=20 ------=_NextPart_000_0005_01C2D28B.B7CBD070 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

My name is rong xie. I am a Student at=20 TU-Munich.

I have a question to Postgresql an Linux.= =20

e.g:

for IBM DB2: I can write a test.sql=20 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= =20 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=20 Postgresql?

Thank you very mach!

Best wish!

rong xie

------=_NextPart_000_0005_01C2D28B.B7CBD070--