basic_query_postgres_gorm.go

// here db is package name where you created the setup

// Here dbConfig stores DB parameters as configs.
postgresStore, err := db.New(dbconfig)
if err != nil {
  logger.Log.Error("errors.postgres.initialize", err)
  return
}

sqlStatement := `select * from users where id=?;`
rows, err := db.DB().Exec(sqlStatement, 1).Rows
defer rows.Close()
if err != nil {
    logger.Log.Error(dbReadError, err)
    return
}

for rows.Next() {
  // use data here
}