我有两个数据库
db_dumped
—包含main_facebookparserresult表中的数据
lk_potok_4
——包含空表main_facebookparserresult
我想将数据从db_dumped复制到lk_potok_4。
我的操作:(无错误(
pg_dump -U postgres -h localhost -t main_facebookparserresult db_dumped | psql lk_potok_4 -U postgres -h localhost
我看到以下错误
SET
...
set_config
------------
(1 row)
SET
SET
SET
SET
SET
SET
ERROR: relation "main_facebookparserresult" already exists
ALTER TABLE
ERROR: relation "main_facebookparserresult_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
ERROR: duplicate key value violates unique constraint "main_facebookparserresult_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY main_facebookparserresult, line 1
setval
--------
34367
(1 row)
ERROR: multiple primary keys for table "main_facebookparserresult" are not allowed
ERROR: relation "main_facebookparserresult_account_type_id_825ffe90" already exists
ERROR: relation "main_facebookparserresult_country_id_42b851f9" already exists
ERROR: relation "main_facebookparserresult_current_city_id_4ea3868d" already exists
ERROR: relation "main_facebookparserresult_edu_type_id_87f43c00" already exists
ERROR: relation "main_facebookparserresult_employment_status_id_808992ba" already exists
ERROR: relation "main_facebookparserresult_employment_type_id_911556be" already exists
ERROR: relation "main_facebookparserresult_family_status_id_ee099277" already exists
ERROR: relation "main_facebookparserresult_gender_id_2a17909b" already exists
ERROR: relation "main_facebookparserresult_home_city_id_a8b99ee3" already exists
ERROR: relation "main_facebookparserresult_relation_id_94f96514" already exists
ERROR: relation "main_facebookparserresult_social_network_type_id_cd0395b0" already exists
ERROR: relation "main_facebookparserresult_university_id_0890ffdd" already exists
ERROR: constraint "main_facebookparserr_account_type_id_825ffe90_fk_main_acco" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserr_country_id_42b851f9_fk_main_coun" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserr_current_city_id_4ea3868d_fk_main_city" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserr_edu_type_id_87f43c00_fk_main_edut" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserr_employment_status_id_808992ba_fk_main_empl" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserr_employment_type_id_911556be_fk_main_empl" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserr_family_status_id_ee099277_fk_main_fami" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserr_relation_id_94f96514_fk_main_rela" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserr_social_network_type__cd0395b0_fk_main_soci" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserr_university_id_0890ffdd_fk_main_univ" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserresult_gender_id_2a17909b_fk_main_gender_id" for relation "main_facebookparserresult" already exists
ERROR: constraint "main_facebookparserresult_home_city_id_a8b99ee3_fk_main_city_id" for relation "main_facebookparserresult" already exists
我做错了什么?我怎样才能理解错误是什么?
您的转储包含main_facebookparserresult
的数据和模式。它正在尝试创建表main_facebookparserresult
,但它已经存在。
您应该删除该表,或者只使用--data-only
转储数据。既然桌子是空的,我建议把桌子放下;这样可以确保正确创建表。