# ID of adapter in migrations

**URL:** <https://www.ruby-forum.com/t/id-of-adapter-in-migrations/164565>\
**Category:** Rails\
**Created:** [April 2, 2009, 5:04pm UTC](https://www.ruby-forum.com/t/id-of-adapter-in-migrations/164565 "2009-04-02T17:04:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![byrnejb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/d2c977/32.png) [@byrnejb](https://www.ruby-forum.com/u/byrnejb)\
**Post date:** [April 2, 2009, 5:04pm UTC](https://www.ruby-forum.com/t/id-of-adapter-in-migrations/164565/1 "2009-04-02T17:04:38Z")

</div>

Rails 2.3

How does one identify the adapter that a migration is using? I have  
some SQL code that only applies if the postgresql adapter is involved  
and I wish to put my execute method inside a suitable conditional.  
However, I cannot see a way to get this information from an instance of  
ActiveRecord::Migration. Nonetheless, some means must exist for  
migrations to work.

How do I ID the DBMS adapter that the migration is using?

---

<div class="post-metadata">

**Author:** ![byrnejb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/d2c977/32.png) [@byrnejb](https://www.ruby-forum.com/u/byrnejb)\
**Post date:** [April 2, 2009, 5:21pm UTC](https://www.ruby-forum.com/t/id-of-adapter-in-migrations/164565/2 "2009-04-02T17:21:35Z")

</div>

On 2 Apr 2009, at 16:04, James B. wrote:

> How do I ID the DBMS adapter that the migration is using?

You could check the class of ActiveRecord::Base.connection

Fred

---

<div class="post-metadata">

**Author:** ![byrnejb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/d2c977/32.png) [@byrnejb](https://www.ruby-forum.com/u/byrnejb)\
**Post date:** [April 2, 2009, 5:56pm UTC](https://www.ruby-forum.com/t/id-of-adapter-in-migrations/164565/3 "2009-04-02T17:56:50Z")

</div>

> How do I ID the DBMS adapter that the migration is using?

if ActiveRecord::Base.configurations[RAILS\_ENV][“adapter”] == “mysql”

etc.

- D

---

<div class="post-metadata">

**Author:** ![byrnejb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/d2c977/32.png) [@byrnejb](https://www.ruby-forum.com/u/byrnejb)\
**Post date:** [April 2, 2009, 9:55pm UTC](https://www.ruby-forum.com/t/id-of-adapter-in-migrations/164565/4 "2009-04-02T21:55:11Z")

</div>

Frederick C. wrote:

> You could check the class of ActiveRecord::Base.connection
> 
> Fred

Works for me. Thanks.