Column is not a relation postgreSQL

Relation of column not defined is a pretty common error in postgresql and nodejs servers. Especially, beginners fail to understand and resolve this error. When you make any changes to your schema in nodejs it doesn’t reflect into postgresql db like in mongodb. You need to manually update the table using pgAdmin.

For example you are receiving error “column feed_id is not a relation of feed”. In order to resolve this you need to go to pgAdmin in your pc open the table feed right click on feed in the sidebar menu and click create column. You create a column with feed_id as name and property as per your nodeJS schema. Now restart the server and everything will work flawlessly. Cheers. Don’t forget to post your queries in the comment section.

manorinfinity Written by:

Complex Problem Solver, Outloud Thinker, An Outstanding Writer, and a very curious human being

Be First to Comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.