3,765
回編集
差分
→科目テーブル
=# ALTER TABLE accounts RENAME COLUMN account TO content;
変更したテーブルをリストアし アプリのデータベースにコピーする
<nowiki>% pg_dump --username=jq --table accounts update_heroku > ../new_accounts.sql
j% psql --username=jq tep5_development < ../new_accounts.sql
SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
SET
SET
ERROR: relation "accounts" already exists
ALTER TABLE
ERROR: relation "accounts_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
COPY 98
setval
--------
98
(1 row)
ERROR: multiple primary keys for table "accounts" are not allowed
ERROR: relation "index_accounts_on_account_cd" already exists
CREATE INDEX</nowiki>