PostgreSQL datatypes equivalent when scaffolding

rubyonrails-talk
1

Hi, I'm trying to make a scaffold for my test application using PostgreSQL 8.3 database. and I remembered on an article for MySQL it uses :string for VARCHAR, :integer for INT, and :text for TINYTEXT, TEXT, MEDIUMTEXT, or LONGTEXT2.

Is there any datatype equivalent with PostgreSQL?

My database is like this

workers: id serial (primary key) first_name character(50) last_name character(50)

users: id serial (primary key) username character(20) password character(20) id_personnel integer(11) (foreign key related with the 'id' field of the 'workers' table)

Additionally, is there a way to import or, rather, migrate the tables' properties (their fields and datatypes) to rails? If there is any, that would be great, because my database is created and would like to use it without doing the "rake db:migrate" thing.

I hope I'm not asking too much. Thanks in advance.

Greetings... The Neurochild

2

Migrations in Rails are independent from your DB. I have successfully migrated a Rails app from MySQL to PostgreSQL without having to change a single line of migration.

3

And what about constraint (primary and foreign keys) and things like that. I know ":string" really mean "character varying" and I need the equivalent of the "character" data type, which is not present in the Rails's data type.

I hope to be wrong but another alternative would be to use the "execute" command followed by the SQL query. Is it possible to do so as mentioned in this article? http://www.robbyonrails.com/articles/2005/11/11/rails-migrations-and-postgresql-constraints. (Yeah I know it's old but it can work on my project's migrations)

Later...

The Neurochild