Rails : Datatypes for ActiveModel- with PostgreSQL

Question

I was using this command to create a model class "Listing". However, I was interested in knowing the relationship between the datatypes of the model and the datatypes of the underlying database. In this case, it is PostgreSQL. So when I type this command:

rails generate scaffold Listing name:string

I want to know what are the possible values I can use to describe the types. What is that dependent on? The underlying database? If so then what happens if the underlying database changes later? Also, where can I get a list of the types I can use here and their capacity with an underlying db of PostgreSQL?

Community · Accepted Answer · 2017-05-23 12:07:22Z

2

That command actually creates migrations for creating tables, etc, on the DB, so that's where you should check the types supported. I would copy/paste here but I think there is no need to.

http://guides.rubyonrails.org/migrations.html#supported-types

UPDATE

The link to the docs does not contain the information anymore. Go to this question Rails 4: List of available datatypes for the full list

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Apr 26, 2012 at 21:18

Ismael

16.7k6 gold badges63 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

banditKing Over a year ago

What about opotimizing the storage.If I want to use smallint versus int etc..... how does that work when using this command to create columns?

Ismael Over a year ago

Well, you can use that command to generate for int, and later go to the migration file and change the line for that column, but remember to do this before running rake db:migrate

Spone Over a year ago

Your link no longer contains the "Supported types" section. The information is available in this answer: stackoverflow.com/a/17918118/1789900

Collectives™ on Stack Overflow

Rails : Datatypes for ActiveModel- with PostgreSQL

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related