PostgreSQL

hornbeastcalmΔιαχείριση Δεδομένων

27 Νοε 2012 (πριν από 4 χρόνια και 11 μήνες)

275 εμφανίσεις

PostgreSQL
s1170153
Noritaka Shimizu
1
Contents

What is PostgreSQL

Download of PostgreSQL

Installation of PostgreSQL

Start PostgreSQL 9.0.4

Reference
2
What is PostgreSQL

PostgreSQL is one of object Relational
Database Management System (ORDBMS) of
the open source. It is the free software
with the BSD license.

PostgreSQL can obtain the source code in
complete form freely.
3
Download of PostgreSQL

Please click
the Download
button of the
right picture.
4
Download of PostgreSQL

Please click the
Download site
of the right
picture.
5
Download of PostgreSQL

Choose Windows
xp 32 bits or
Windows xp 64
bits among a
right picture,
and please click
it.
6
Installation of PostgreSQL

Please click “Next
button”.
7
Installation of PostgreSQL

Please click “Next
button”.
8
Installation of PostgreSQL

Please click “Next
button”.
9
Installation of PostgreSQL

Please set a
password.
And please click
“Next button”.
10
Installation of PostgreSQL

Please click “Next
button”.
11
Installation of PostgreSQL

Choose the
“Japanese,Japan”
and, Please click
“Next button”.
12
Installation of PostgreSQL

Please click
“Next button”.
13
Installation of PostgreSQL

Complete the
installation.

Please click
“finish
button”.
14
Start PostgreSQL9.0.4

Start pgAdmin III

Right click database from Object browser,
select new database.

Input database name(example-sample1),
select owner -> click OK.
15
Start PostgreSQL9.0.4

Create table
friend(firstna
me char(15),
Lastname
char(20),
city
char(15),state
char(2),age
integer);
16
Start PostgreSQL9.0.4

Insert into
friend
value('Mike' ,
'Nichols',
'Tempa',
'FL',
19);
17
Start PostgreSQL9.0.4

Select * from
friend;
18
Reference

NPO
法人 日本
PostgreSQL
ユーザ会

http://www.postgresql.jp/
19
Thank you for your listening
20