3,765
回編集
差分
→摘要テーブル 変更あり
=# ALTER TABLE descriptions RENAME COLUMN jiin_id TO note_id;
リストア コピー
% pg_dump --username=jq --table descriptions update_heroku > ../new_descriptions.sql
<nowiki>% psql --username=jq tep5_development < ../new_descriptions.sql
SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
SET
SET
ERROR: relation "descriptions" already exists
ALTER TABLE
ERROR: relation "descriptions_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
COPY 640
setval
--------
871
(1 row)
ERROR: multiple primary keys for table "descriptions" are not allowed
ERROR: relation "index_descriptions_on_account_id" already exists
CREATE INDEX
ERROR: relation "index_descriptions_on_user_id" already exists
CREATE INDEX
ALTER TABLE
ERROR: relation "public.jiins" does not exist</nowiki>
