blob: 8837630aa31101da3c45a8472745edf2b10cc2db (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
PostgreSQL 7.4.8 �Ǥμ¹���
0) PostgreSQL ������( postmaster ������ )�����롣
/etc/rc.d/pgsql start
1) �桼�� fml �κ���
% su root
# su pgsql
> createuser --password fml
2) �ǡ����١��� fml �κ���
% su root
# su pgsql
> createdb fml
3) �ơ��֥� ml ����
% su root
# su pgsql
> psql fml
Welcome to psql 7.4.8, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
fml=#
�⤷���ϰ��̥桼����������Ȥ���ľ�ܥ����������롣
% psql -h localhost -U fml --password
Password:
Welcome to psql 7.4.8, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
fml=#
[INFO] mysql �θ��ܤ�Ʊ����Τ�(����)�Ȥ���Τǡ������Ȥ���
% psql -h localhost -U fml --password < create_table.sql
% psql -h localhost -U fml --password < test.sql
% psql -h localhost -U fml --password < drop_table.sql
4) test
../mysql/getline.pl postgresql
��Ͽa) �ǡ����١��� fml �κ����
% su root
# su pgsql
> dropdb fml
��Ͽb) �桼�����ѥ���ɤǤΥ�������
% psql -h localhost -U fml --password
��Ͽz) documents
http://www.postgresql.jp/document/pg746doc/html/
------------------------------------------------------------
$FML$
|
