Skip site navigation (1) Skip section navigation (2)

help me!!

From: "XIE, Rong" <rong(dot)xie(at)stud(dot)tu-muenchen(dot)de>
To: <"Undisclosed-Recipient:;"(at)postgresql(dot)org>
Subject: help me!!
Date: 2003-02-12 10:41:44
Message-ID: 000801c2d283$564c39a0$d2e0f48a@ips64m (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-supportpgsql-adminpgsql-docspgsql-generalpgsql-hackers
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 

Responses

pgsql-docs by date

Next:From: Wilson, ScottDate: 2003-02-12 20:54:44
Subject: Row ordering difference in regression test output
Previous:From: Vicki BrownDate: 2003-02-12 04:01:24
Subject: Suggested improvements to INSTALL file "Short Version"

pgsql-admin by date

Next:From: vivek K.Date: 2003-02-12 14:30:38
Subject: Connection refused
Previous:From: Ret MartinDate: 2003-02-12 09:45:51
Subject: Migrating database from v 7.3 -> 7.2

pgsql-hackers by date

Next:From: Daniel KalchevDate: 2003-02-12 11:52:31
Subject: Re: Changing the default configuration (was Re:
Previous:From: Hans-Jürgen SchönigDate: 2003-02-12 07:49:07
Subject: Re: [HACKERS] PostgreSQL Tuning Results

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2003-02-12 12:33:17
Subject: PostgreSQL Windows port strategy
Previous:From: Jean-Michel POUREDate: 2003-02-11 08:44:23
Subject: Running pgAdmin2 under Unix: Wine or HBasic

pgsql-general by date

Next:From: DeepaDate: 2003-02-12 12:50:31
Subject: Hi,
Previous:From: Viacheslav N TararinDate: 2003-02-12 10:02:26
Subject: DOMAIN constraints bug or feature

pgadmin-support by date

Next:From: Matthew J. HarmonDate: 2003-02-12 23:25:08
Subject: Import Wizard Error: Number 9, Subscript out of range
Previous:From: Dave PageDate: 2003-02-11 09:30:36
Subject: Re: Problem Using Create Function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group