psql数据导入

第一步：
C:\Program Files\PostgreSQL\8.3\bin>psql -U 用户名 数据库名
第二步：
C:\Program Files\PostgreSQL\8.3\bin>psql -U postgres dc
Password for user postgres:
第三步：
C:\Program Files\PostgreSQL\8.3\bin>psql -U postgres dc
Password for user postgres:
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

dc=#
第四步：
C:\Program Files\PostgreSQL\8.3\bin>psql -U postgres dc
Password for user postgres:
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

dc=# \i C:/dc.sql
。。。。。。。。。。。。。。。

C:\Program Files\PostgreSQL\8.3\bin>psql -U postgres dc
Password for user postgres:
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

dc=# \i C:/dc.sql
SET
SET
SET
SET
SET
SET
psql:C:/dc.sql:16: ERROR: language "plpgsql" already exists
ALTER LANGUAGE
SET
SET
SET
psql:C:/dc.sql:38: ERROR: relation "dcda" already exists
ALTER TABLE
psql:C:/dc.sql:52: ERROR: relation "dcdesktopannouncement_id_seq" already exist
s
ALTER TABLE
ALTER SEQUENCE
setval
--------
12
(1 row)

psql:C:/dc.sql:78: ERROR: relation "dctype" already exists
ALTER TABLE
psql:C:/dc.sql:92: ERROR: relation "dctype_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
setval
--------
13
(1 row)

psql:C:/dc.sql:119: ERROR: relation "dcuser" already exists
ALTER TABLE
psql:C:/dc.sql:133: ERROR: relation "user_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
setval
--------
1
(1 row)

ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:C:/dc.sql:190: ERROR: duplicate key value violates unique constraint "pkda
"
CONTEXT: COPY dcda, line 1: "1 wwww 鈥媤www 2010-02-19 18:37:58.734+08
f 1"
psql:C:/dc.sql:211: ERROR: duplicate key value violates unique constraint "pk_d
ctype"
CONTEXT: COPY dctype, line 1: "1 骞冲彴鍏憡"
psql:C:/dc.sql:220: ERROR: duplicate key value violates unique constraint "pk_u
ser"
CONTEXT: COPY dcuser, line 1: "1 admin 123456"
psql:C:/dc.sql:228: ERROR: multiple primary keys for table "dctype" are not all
owed
psql:C:/dc.sql:236: ERROR: multiple primary keys for table "dcuser" are not all
owed
psql:C:/dc.sql:244: ERROR: multiple primary keys for table "dcda" are not allow
ed
psql:C:/dc.sql:252: ERROR: constraint "fpk_dcda_dctype" for relation "dcda" alr
eady exists
REVOKE
REVOKE
GRANT
GRANT
dc=#结束了！！！