Help us understand the problem. What is going on with this article?

Railsのmigration時にafterを指定しても、場所指定できない(PostgreSQL)

More than 1 year has passed since last update.

動作検証

CREATE TABLE

class CreatePictures < ActiveRecord::Migration[5.2]
  def change
    create_table :pictures do |t|
      t.string :title, null: false
      t.string :subtitle
      t.timestamps
    end
  end
end

mysqlの場合

title subtitle created_at updated_at

postgresの場合

title subtitle created_at updated_at

この時点では変わらない

ADD COLUMN

class AddUrlToPictures < ActiveRecord::Migration[5.2]
  def change
    add_column :pictures, :url, :text, null: true, after: :subtitle
  end
end

mysqlの場合

title subtitle url created_at updated_at

postgresの場合

title subtitle created_at updated_at url

ここで、PostgreSQLの場合はurlが一番最後に追加される。
そもそもPostgreSQLにAFTERの機能がないため、指定しても意味ない。

Why do not you register as a user and use Qiita more conveniently?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away