POSTGRESQL  ̿  Խ ġ 

<--------------
MYSQL ̿  Խ POSTGRESQL  ϵ ϴ.
<-------------

ǻ  !!

̿ : 

ġ
	POSTGRESQL 6.5 (Ϲ  ׽Ʈ غ ,    ̶ )
	Apache 1.3.x
	PHP 3.12 (-with-pgsql) 
	
ġ 

apache  nobody  ϹǷ ǻ nobody  sql  ϵ ϴ.

 postgres  ̿ nobody   Ѵ.

$ createuser
Enter name of user to add ---> nobody 
Enter user's postgres ID or RETURN to use unix user ID: 99 ->
Is user "nobody" allowed to create databases (y/n) y
Is user "nobody" a superuser? (y/n) n
createuser: nobody was successfully added

̷ Ѵ.	 

 nobody  board ̸  database ..

$createdb board 

  Ư 丮 ġմϴ.

tar xvzf pgbpard

 board  postgres.sql  table  ϴ.

CREATE SEQUENCE plazainc INCREMENT 1 START 1; /* ڵ  SEQUENCE : TABLE ̸ inc δ. */
                                              /*  ü̺ ߰Ҷ   ־ Ѵ. */

CREATE TABLE plaza (
no1 int4 DEFAULT nextval('plazainc') PRIMARY KEY, /* ڵ SEQUENCE ⿡ .. */ 
num int4 DEFAULT 0 NOT NULL ,
day datetime NOT NULL,
host varchar(100),
name varchar(50),
passwd varchar(13),
email varchar(100),
url varchar(150),
title varchar(150),
text text,
refer int4 DEFAULT 0 NOT NULL,
reyn int2 DEFAULT 0 NOT NULL,
reno int4 DEFAULT 0 NOT NULL,
rede int4 DEFAULT 0 NOT NULL,
reto int4 DEFAULT 0 NOT NULL
);

CREATE INDEX plazanumindex ON plaza(num);  /* ؽ   */
CREATE INDEX plazarenoindex ON plaza(reno); /* ؽ  */

--------------------------------------------------------------

nobody  ..

$ psql -f postgres.sql board
CREATE SEQUENCE plazainc INCREMENT 1 START 1;
CREATE

CREATE TABLE plaza (
no1 int4 DEFAULT nextval('plazainc') PRIMARY KEY,
num int4 DEFAULT 0 NOT NULL ,
day datetime NOT NULL,
host varchar(100),
name varchar(50),
passwd varchar(13),
email varchar(100),
url varchar(150),
title varchar(150),
text text,
refer int4 DEFAULT 0 NOT NULL,
reyn int2 DEFAULT 0 NOT NULL,
reno int4 DEFAULT 0 NOT NULL,
rede int4 DEFAULT 0 NOT NULL,
reto int4 DEFAULT 0 NOT NULL
);
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'plaza_pkey' for table 'plaza'
CREATE

CREATE INDEX numindex ON plaza(num);
CREATE
CREATE INDEX renoindex ON plaza(reno);
CREATE
EOF
-------------------------------------------------------------

 include 丮  

db.ph Ͽ 

$db_constring = "dbname=board" ; ٸ   ٸ ȣƮ  ̿Ҷ ȴ.

$db_constring = "host=XXX.XXX.XXX.XXX user=young password=XXXXXXX dbname=board" ;
̷ ָ ȴ...

  .

test غ...

