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 







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
Wed, 12 Feb 2003 11:41:44 +0100
"XIE, Rong" <rong.xie@stud.tu-muenchen.de>
help me!!
hi rong...

well...is the postmaster running ? 

there are a couple of postintallation steps ...

    first, you must create and prepare the data files.
    lets assume your pgSQL is installed on /usr/local/pgsql, right ? 

    1 . make dir where your data files are going to live, say data
        root# mkdir /usr/local/pgsql/data

    2 . lets make user postgres the owner of this dir
        root# chown postgres /usr/local/pgsql/data    

    3 . let postgres init dababase on this dir
        root# su postgres
        postgres# /usr/local/pgsql/bin/initdb -D  /usr/local/pgsql/data

    4 . start the postmaster..
        set the environment var PGDATA=/usr/local/pgsql/data
        postgres# /usr/local/pgsql/bin/postmaster -i

        -i allows tcp  connections to the db. 

    5 .start the client 
        postgres# /usr/local/pgsql/bin/psql

        There is are various front end GUI's to postgres..one I use is pgAccess-- go to their page and lurk a bit .. 

  If you don't have the postgresql docs, you should take it on the postgresql.org site because there are a lot of options to postgresql be compiled with depending on further use you are going to do..to conect via  Java, C++... and any way...printing this docs you'll find most of your answers faster. There are the admin, programmer, user...guides..and a small tutorial..

    Good luck .. and best regards,

Andrew








hi rong...
 
well...is the postmaster running ? 
 
there are a couple of postintallation steps 
...
 
    first, you must create and 
prepare the data files.
    lets assume your pgSQL is 
installed on /usr/local/pgsql, right ? 
 
    1 . make dir where your data 
files are going to live, say data
        root# mkdir 
/usr/local/pgsql/data
 
    2 . lets make user postgres the 
owner of this dir
        root# chown postgres 
/usr/local/pgsql/data    
 
    3 . let postgres init 
dababase on this dir
        root# su 
postgres
        postgres# 
/usr/local/pgsql/bin/initdb -D  /usr/local/pgsql/data
 
    4 . start the 
postmaster..
        set the 
environment var PGDATA=/usr/local/pgsql/data

        postgres# 
/usr/local/pgsql/bin/postmaster -i
 

        -i allows tcp  connections to 
the db. 
 
    5 .start the client 
        postgres# 
/usr/local/pgsql/bin/psql
 
        There is are various front end 
GUI's to postgres..one I use is pgAccess-- go to their page and lurk a bit .. 

 

  If you don't have the postgresql docs, 
you should take it on the postgresql.org site because there are a lot of options 
to postgresql be compiled with depending on further use you are going to do..to 
conect via  Java, C++... and any way...printing this docs you'll find 
most of your answers faster. There are the admin, programmer, user...guides..and 
a small tutorial..
 
    Good luck .. and best regards,
 
Andrew
Thu, 13 Feb 2003 20:21:50 +0100
"Andres Ledesma" <aledes@telefonica.net>
Re: [ADMIN] help me!!