CODEWITHSUNDEEP
ruby-on-railspostgresql
Anand
Anand

Reputation: 3760

Are 'fields' and 'types' allowed names for rails postgresql tables?

I want to name my tables in postgresql as 'fields' and 'types', to be used in a rails 4 (ActiveRecord) app - are these kinds of common words acceptable as names, or will they clash with rails or postgresql reserved names?

Upvotes: 1

Views: 471

Answers (1)

BigRon
BigRon

Reputation: 3282

This is a possible duplicate of: Reserved names with ActiveRecord models

Here is additional info regarding reserved words in postgres: http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html

Ultimately, the answer is no, 'fields' is not a reserved name for rails or postgres; however, 'types' may cause some problems. Type is an ActionView method per the following: http://api.rubyonrails.org/classes/ActionView/Template.html#method-i-type

Upvotes: 2

Related Questions