I would like to use psql triggers in rails app? HOw do i use this line of code - createlang plpgsql database_name?

Question

If i am gonna use postgres triggers in rails app, i can use execute { create triggger } for creating trigger in migration file. But where am i suppose to write these lines of "createlang plpgsql databasename;"

Answer 1

Use the SQL execute("CREATE LANGUAGE plpgsql") instead, and put this statement in your standard migration.