relation \"users\" does not exist means that there is no users table in your database. Has the table been created in the local database?

Keep in mind that SQL language is case-insensitive when not using quotes. If the table in the database is called Users and GORM is trying to query users, this could be the reason why your code results in an error. Is the table correctly named in the migration file?