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

Question

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?

Community · Accepted Answer · 2017-05-23 12:20:35Z

2

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

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Jan 27, 2015 at 4:37

BigRon

3,3023 gold badges25 silver badges49 bronze badges

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

2 Comments

Anand Over a year ago

I noticed in the rails reserved link in the other SO thread you linked, that the word type is listed as reserved. If I have a types table and use type in the singular across rails, could that cause any trouble?

BigRon Over a year ago

My fault. Yes, you are right. I'll revise my answer.

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related