3,765
回編集
差分
→12-16
ALTER TABLE
COPY 14885</nowiki>
update_dump=# ALTER TABLE journals RENAME COLUMN client_id TO other_id;
ALTER TABLE
update_dump=# ALTER TABLE journals ADD COLUMN client_id integer;
ALTER TABLE
update_dump=# ALTER TABLE journals RENAME COLUMN jiin_id TO note_id;
ALTER TABLE
=# update journals set account_id = 99 where account_id is null;
UPDATE 10379 % pg_dump -t journals update_dump > ../journals_latest.sql
==== 以前 ====