개발/postgresql(2)
-
PostgreSQL 기본 클라이언트 psql 사용
psql 쉘 옵션 [root@linux root]# psql --help This is psql 7.4.1, the PostgreSQL interactive terminal. Usage: psql [OPTIONS]... [DBNAME [USERNAME]] General options: -d DBNAME specify database name to connect to (default: "root") -c COMMAND run only single command (SQL or internal) and exit -f FILENAME execute commands from file, then exit -l list available data..
2012.01.14 -
PostgreSQL 설치
PostgreSQL 설치 postgresql-7.4.5.tar.gz 설치 [root@localhost postgresql-7.4.5] ./configure [root@localhost postgresql-7.4.5] gmake [root@localhost postgresql-7.4.5] su [root@localhost postgresql-7.4.5] gmake install postgre 그룹 및 유저추가: [root@localhost postgresql-7.4.5] groupadd postgres [root@localhost postgresql-7.4.5] adduser postgres -g postgres -d /usr/local/pgsql [root@localhost postgresql-7.4.5..
2012.01.12